K
Kelly Thompson
My problem in 12.50 hours is 12:30, How do I get excel to convert the first
one to the second one?
one to the second one?
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.
A
Arvi Laanemets
Hi
=12.50/24
and format as time
Arvi Laanemets
=12.50/24
and format as time
Arvi Laanemets
K
Kelly Thompson
Ok that helps alot now what is the 12.5 is a caluaction for other cells?
K
Kelly Thompson
this excel sheet is a monthly time sheet so it is adding the hours up for the
days work. So how can I convert this over?
Thansk you
Kelly
days work. So how can I convert this over?
Thansk you
Kelly
P
Peo Sjoblom
Just sum the hours then convert the sum
=SUM(A1:A20)/24
format as [hh]:mm
Regards,
Peo Sjoblom
=SUM(A1:A20)/24
format as [hh]:mm
Regards,
Peo Sjoblom
K
Kelly Thompson
Anything over 24 hours just starts over(like 40 hours is now 16:00).
Thanks again
Kelly
Thanks again
Kelly
Peo Sjoblom said:Just sum the hours then convert the sum
=SUM(A1:A20)/24
format as [hh]:mm
Regards,
Peo Sjoblom
Kelly Thompson said:this excel sheet is a monthly time sheet so it is adding the hours up for the
days work. So how can I convert this over?
Thansk you
Kelly
M
Michael
Hi Kelly
I guess you could either leave the original column in place and hide it when
not required, so that other calcs are not affected.......or add the 12:30*24
( which is the reverse of Arni's equation) to the other calculations.
Remembering of course, that you will use a cell reference not the actual
time. eg... if 12:30 is in cell A2, you will add A2*24 to your calculations.
HTH
Michael
I guess you could either leave the original column in place and hide it when
not required, so that other calcs are not affected.......or add the 12:30*24
( which is the reverse of Arni's equation) to the other calculations.
Remembering of course, that you will use a cell reference not the actual
time. eg... if 12:30 is in cell A2, you will add A2*24 to your calculations.
HTH
Michael
F
Frank Kabel
Hi
format the resulting cell with the custom format
[hh]:mm
--
Regards
Frank Kabel
Frankfurt, Germany
format the resulting cell with the custom format
[hh]:mm
--
Regards
Frank Kabel
Frankfurt, Germany
Kelly Thompson said:Anything over 24 hours just starts over(like 40 hours is now 16:00).
Thanks again
Kelly
Peo Sjoblom said:Just sum the hours then convert the sum
=SUM(A1:A20)/24
format as [hh]:mm
Regards,
Peo Sjoblom
Kelly Thompson said:this excel sheet is a monthly time sheet so it is adding the hours up
for the
days work. So how can I convert this over?
Thansk you
Kelly
:
Ok that helps alot now what is the 12.5 is a caluaction for other
cells?
:
Hi
=12.50/24
and format as time
Arvi Laanemets
message
My problem in 12.50 hours is 12:30, How do I get excel to convert
the
first
one to the second one?
K
Kelly Thompson
I just Figured it out thenk you all for your help.