Time conversions

M

MDJ

How do I convert an integer value into a time value in MS Excel (97)??

For example 13 becomes 00:13:00 (13 mins) or 65 becomes 01:05:00 (1hr
5mins)??

Is there a function I could use ??

Many thanks
 
N

Niek Otten

Time is stored as a fraction of a day. So 13 minutes is 13/24/60, or 65
minutes =65/1440.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel
 
R

Ron Rosenfeld

How do I convert an integer value into a time value in MS Excel (97)??

For example 13 becomes 00:13:00 (13 mins) or 65 becomes 01:05:00 (1hr
5mins)??

Is there a function I could use ??

Many thanks
Click to expand...

In addition to what Nick wrote, you could also use the TIME worksheet function:

=TIME(hrs, mins, secs)

=TIME(0,13,0)

=TIME(0,65,0)


--ron
 
Top