NA Excel and clock entries

Let'sgoflying!

Let'sgoflying!

Touchdown! Greaser!
Joined
Feb 23, 2005
Messages
20,862
Location
west Texas
Display Name
Display name:
Dave Taylor
I need to be able to enter clock times ie 5hrs 33 mins into a cell, then do some calculations between such cells ie
5:33 times 350$ per hour.
Googlefu not successful on this one, any ideas?
 
Why hours and minutes instead of hours and tenths? 5:33 = 5.5
 
C1=hours
D1=minutes
E1=dollar rate
F1=C1+D1/60 (decimal hours)
G1=E1*F1 (total charge)


Oh. You want to parse "5:33" If you enter it as a string....

A1="5:33"
B1=FIND(A1,":",1)
C1=VALUE(LEFT(A1,B1-1))
D1=VALUE(RIGHT(A1,LEN(A1)-B1))
E1,F1,G1...as above

You can use TIME formulas but sorry I did enough....
 
Last edited:
multiply the cell by 24 and format the cell as number instead of time.

So in column B, format it so it is a number
Cell B1 contains:
=A1*24

your 5:33 in A1 becomes 5.55 in B1
from there it's just a decimal number
 
buh, I didn't know it would do that. Thanks
Thanks everyone.

EdFred said:
multiply the cell by 24 and format the cell as number instead of time.

So in column B, format it so it is a number
Cell B1 contains:
=A1*24

your 5:33 in A1 becomes 5.55 in B1
from there it's just a decimal number
Click to expand...
 
where's the time data coming from? What format? Excel does have time calculations.I think the version of Excel matters too.
 
You must log in or register to reply here.
Back
Top