Excel Formula Question

joroma · 28 Jun 2006 at 08:48

One for the bright boys out there.

I've got a timesheet programme in EXCEL that adds up all my hours worked in hours and minutes giving me a total for the week of say 39hrs 42mins.

I want to display that total in another cell as a decimal ie 39.7hrs. Is there an easy way of doing that???

Hope this questions ok in this forum. If not mods are welcome to move/delete.

joroma · 28 Jun 2006 at 13:18

They are in the format xx:yy ie the cell is formatted to display hh:mm.

I want to display the time period as a decimal in a seperate cell.

joroma · 28 Jun 2006 at 13:41

Thanks Nelson that works a treat. I just need to try and understand how now................................

joroma · 28 Jun 2006 at 15:09

My initial elation was premature. This only works if the total hours and minutes is less than 24!

I need to be able to convert 225hrs 45mins (displayed as 225:45) into 225.75hrs (displayed as 225.75). I've tried googling but can't find anything I can make work.

joroma · 28 Jun 2006 at 19:13

|Ric| said:
lol that is completely unnessecary what I just did. Aslong as you store it as a time then:
=INT(TEXT(A1, "[h]"))+MINUTE(A1)/60
will achieve what you want

Thanks Ric this appears to work fine. I'll do some more testing when I get back to the office tomorrow!