add 10,0015:15 hours to 03:53 Hours to a total time
Add it in two stages, 5000 and then another 5000.
--
__________________________________
HTH
Bob
"Alan" wrote in message
...
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).
|