Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Convert a number to time in Excel
1 view
Skip to first unread message
Apollo Creed
Mar 13, 2003, 4:10:30 AM3/13/03
to
Cant find this in the help-section...
my number is 7,25 meaning 7 hrs and 15 minutes , how do I convert this
automatically in XCL?
Thanks
AC
Nils
Mar 13, 2003, 5:18:21 AM3/13/03
to
To make a number look and act like time, you have to
understand how Excel stores and manages date and time.
A date is calculated as the number of days after 1/1/1900.
This means March 14 2003 is 37694
understand how Excel stores and manages date and time.
A date is calculated as the number of days after 1/1/1900.
This means March 14 2003 is 37694
A day is devided into hours in the same fasion. 1=1 day,
hence 0,5 is 12 hours.
1 minute is 1/24/60
To make the cell look like time, adjust the cell
properties.
>.
>
Orlando Magalhães Filho
Mar 16, 2003, 3:44:51 PM3/16/03
to
Hi Apollo Creed,
Convert your number to minutes multiplying by 60 and use Time() worksheet
function, like this:
=TIME(0,7.25*60,0)
See Excel help for Time() arguments.
HTH
---
Orlando Magalhães Filho
(So that you get best and rapid solution and all may benefit from the
discussion, please reply within the newsgroup, not in email)
"Apollo Creed" <anta...@hotmail.com> escreveu na mensagem
news:bWXba.37623$Rc7.5...@news2.e.nsc.no...
0 new messages