Spreadsheet formula for overtime.

  Tulips 18:24 30 Apr 2009
Locked

I have a spreadsheet with which to keep a track of my overtime. I have the following formula in column I =SUM(I5:I28) with the format "custom hh:mm" but when the overtime get's greater than 24 hours it displays 00:00 what do you have to do to display 25:30 please.

  Zak 18:29 30 Apr 2009

[hh]:mm

The square brackets should do the trick.

  Tulips 20:59 30 Apr 2009

That did do the trick, cheers Zak

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone