Excel does this calculation for you by this formula: =TIME(0,A1,0)
Regards,
Stefi


€žFred Smith€� ezt Ã*rta:

Excel keeps times in days. So an hour is 1/24 of a day, and minutes are
1/24/60 of a day. So if your minutes are in a1, use:
=a1/24/60
and add it to your time in the next column.

\Regards,
Fred.

"TheMilkGuy" wrote in message
...
Hi folks!

I'm doing some arithmetic that eventually gives me an answer of 19.
Technically that answer is 19 minutes. I need to know how to conver
that to ":19" or "0:19" so that I can properly add it to the 13:00 in
the next column.

Perhaps I'm just sleep-deprived... I have been scouring the internet
but I just can't find the phraseology I need to find the answer.

Many thanks!
Craig