G
Guest
I am creating a time sheet. I need to convert a time format (7:30) to a
decimal format (7.50). How do I do this?
decimal format (7.50). How do I do this?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
=A1*24
Format cell as General
Format cell as General
G
Guest
Multiply by 24 format cell as general
G
Gary
If the time is in A1, in B1 enter =(A1-INT(A1))*24
Hope this helps.
Hope this helps.
K
Karen
Hello, I have been reading the posts on converting time to a decimal. It
worked for 36:24:03, but I can't get it to work for 2:14:03. I get a "value"
error. Can you help me with this please
worked for 36:24:03, but I can't get it to work for 2:14:03. I get a "value"
error. Can you help me with this please
T
T. Valko
Assume cell A1 = 2:14:03
Enter this formula in a cell:
=ISNUMBER(A1)
What result do you get? If A1 is a real time value then this formula will
return TRUE.
If you are using this formula:
=A1*24
And it retuns a #VALUE! error then there's a problem with what's entered in
cell A1.
Enter this formula in a cell:
=ISNUMBER(A1)
What result do you get? If A1 is a real time value then this formula will
return TRUE.
If you are using this formula:
=A1*24
And it retuns a #VALUE! error then there's a problem with what's entered in
cell A1.
K
Karen
Thank you. I will try again. I appreciate your answer.
K
Karen
Here I am again. I tried every format available and nothing works. The
formula does come back false every time. Any other suggestions besides doing
it manually?
Thank you.
Karen
formula does come back false every time. Any other suggestions besides doing
it manually?
Thank you.
Karen
K
Karen
Thank you. I've done that before when doing a copy & paste. I will try that.
Karen
Karen