ADD TIME IN EXCESS OF 24 HOURS

G

Guest

i want to input time as hh:mm and add this together carrying the total
forward. When i go over 24 hours the figure resets to zero
 
G

Guest

Actually only the display starts over again, the numbers are there, use
custom format [hh]:mm or for decimal hours multiply with 24 and format as
general


Regards,

Peo Sjoblom
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert 29.08 hours (shown in decimal form) to time shown in "hh:m 1
Date/Time concatenation 4
How do I add hours and minutes without 24 hour limit 1
TIME CALCULATION 5
Adding Times 7
function to add time totals over 24 hours 2
Adding Days and Hours 8
Adding hours to a time 2

Top