Alistair has attended:
Excel Advanced course
Time; hours:Mins
Hi,
I'm working in hours and minutes on a spreadsheet. I wish to add up a bunch of times to find the total time. For example 5 days at 8:30 hours (or 8.5) should equal 42:30 (or 42.5), but excel displays the total as 18:30. I have tried the diferent formats for time but can't find anything suitable. Any suggestions?
Cheers
ALi.