Time Conversion

[ELP]

I need help in converting time. I am using data from a time clock which
currently formats time as 1.5. When I input this data into a cell how can I
have it formated to read 1 hour and 30 minutes (1:30)

T.I.A.

Ed

 

[Jason]

What you could do in an adjacent row or column is format
them as Time and then using a formula, divide the input
time by 24(hours in a day).

 

[Wayne]

-----Original Message-----
I need help in converting time. I am using data from a time clock which
currently formats time as 1.5. When I input this data into a cell how can I
have it formated to read 1 hour and 30 minutes (1:30)

T.I.A.

Ed

I got this to work. First I had NOW() in a cell. TODAY()

in a cell. I did cell 1 - cell 2. I then used custom
format h:mm.ss. Hopes this helps.

 

[Ron Rosenfeld]

I need help in converting time. I am using data from a time clock which
currently formats time as 1.5. When I input this data into a cell how can I
have it formated to read 1 hour and 30 minutes (1:30)

T.I.A.

Ed

Excel stores time as a fraction of a day. So 1:30 = 1.5/24.

If your time is in A1, in B1 enter the formula =A1/24. Format
(Format/Cells/Number/Custom) [h]:mm


--ron

 

[danw]

Do you need to calculate with the 1:30 format, or can it
be just text? For just text, you can do this (A1 is the
cell that has 1.5 value)

=INT(A1) This will give you the hour part (cell1)
=60*(A1-(INT(A1))) This will give you the minutes (cell2)
format those two cells as text then
concatenate(cell1,":",cell2)

Something like that?