Time conversions

  • Thread starter Thread starter MDJ
  • Start date Start date
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
 
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
 
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
 
Back
Top