1. You can't type 10311:20 in a cell without it becoming text, so just to
enter that value you need to use
=10311/24+"00:20"
and format as [hh]:mm will return a time value of 10311:20
then you can add time to it with a normal addition, assume you put that in
A1 and in A2 you have
00:40 (40 minutes)
=A1+A2
returns 10312:00
--
Regards,
Peo Sjoblom
(No private emails please)
"Avery Wagg" wrote in message
...
I'd like to add 10,311 hours and 20 minutes (10311:20), onto a calculated
time (in minutes), but I can't figure out how to turn this large number
into something excel can add time to.
Any hints?
..Avery
|