Hi, I'm facing problem summing time. Not sure how to handle it.
Capture.PNG
Thanks
Thomas
Hi, I'm facing problem summing time. Not sure how to handle it.
Capture.PNG
Thanks
Thomas
Format the total cell as [h]:mm:ss ... note the square brackets round the h.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
You need to apply a Custom Format in cell C5 of:
[h]:mm:ss
to prevent the hours from wrapping at 24. This is the English version, but in Denmark you will need to use the initials for hours, minutes and seconds - the important bit is to put square brackets around the hours term.
Hope this helps.
Pete
Thanks both. Works perfectly!
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks