Hi
i would like to how to add up a number of hours and minutes in a spreadsheet
what i mead is this
14:35:00
13:00:00
11:11:00
13:00:00
13:00:00
00:00:00
07:00:00
what i need it the formula to get it to say 71:46 and not 23:46:00 any ideas
Do a custom number format for the results cell and make it :mm
That should get the result to display properly.
Coffeeholic:
Do a custom number format for the results cell and make it :mm
That should get the result to display properly.
[/quote]
hi mate had i bit of trouble, but did as you said, thanks