Base 60

  • Thread starter Thread starter Gnet
  • Start date Start date
G

Gnet

I have a value of 163 minutes, how do I convert it to a
numeric value of 2:43 (2hrs:43mins)? Any help would be
greatly appreciated.
 
XL stores times as fractional days, so

A1: 163
A2: =A1/(24*60)

Format with Format/Cells/Number/Custom [h]:mm

A bit more efficient would be

A2: =A1/1440
 
Thanks so much, that worked!!
-----Original Message-----
Format the cell as time and just enter it as 0:163

This will display as 2:43

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

---------------------------------------------------------- ------------------
It's easier to beg forgiveness than ask permission :-)
---------------------------------------------------------- ------------------






---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.593 / Virus Database: 376 - Release Date: 20/02/2004


.
Click to expand...
 
This worked perfect!!
Thanks for all your help!!
-----Original Message-----
XL stores times as fractional days, so

A1: 163
A2: =A1/(24*60)

Format with Format/Cells/Number/Custom [h]:mm

A bit more efficient would be

A2: =A1/1440




Gnet said:
I have a value of 163 minutes, how do I convert it to a
numeric value of 2:43 (2hrs:43mins)? Any help would be
greatly appreciated.
Click to expand...
.
Click to expand...
 
Back
Top