add 10,0015:15 hours to 03:53 Hours to a total time
Unfortunately 10,000 hours is an Excel limit, you have to find a workaround
for handling greater number of hours (e.g. work with plain numbers).
Regards,
Stefi
€žAlan€ť ezt Ă*rta:
when adding a hour number larger that 10,000 to another time number the
formula will not give a correct answer. Tried several time formats and
nothing worked. I need a format that is (HH,HHH:MM).
|