My problem in 12.50 hours is 12:30, How do I get excel to convert the first
one to the second one?

Hi

=12.50/24
and format as time


Arvi Laanemets


"Kelly Thompson" wrote in message
...
My problem in 12.50 hours is 12:30, How do I get excel to convert the
first
one to the second one?

Ok that helps alot now what is the 12.5 is a caluaction for other cells?

"Arvi Laanemets" wrote:

Hi

=12.50/24
and format as time


Arvi Laanemets


"Kelly Thompson" wrote in message
...
My problem in 12.50 hours is 12:30, How do I get excel to convert the
first
one to the second one?

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

"Kelly Thompson" wrote:

Ok that helps alot now what is the 12.5 is a caluaction for other cells?

"Arvi Laanemets" wrote:

Hi

=12.50/24
and format as time


Arvi Laanemets


"Kelly Thompson" wrote in message
...
My problem in 12.50 hours is 12:30, How do I get excel to convert the
first
one to the second one?

Just sum the hours then convert the sum

=SUM(A1:A20)/24

format as [hh]:mm


Regards,

Peo Sjoblom

"Kelly Thompson" wrote:

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

"Kelly Thompson" wrote:

Ok that helps alot now what is the 12.5 is a caluaction for other cells?

"Arvi Laanemets" wrote:

Hi

=12.50/24
and format as time


Arvi Laanemets


"Kelly Thompson" wrote in message
...
My problem in 12.50 hours is 12:30, How do I get excel to convert the
first
one to the second one?

Anything over 24 hours just starts over(like 40 hours is now 16:00).
Thanks again
Kelly

"Peo Sjoblom" wrote:

Just sum the hours then convert the sum

=SUM(A1:A20)/24

format as [hh]:mm


Regards,

Peo Sjoblom

"Kelly Thompson" wrote:

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

"Kelly Thompson" wrote:

Ok that helps alot now what is the 12.5 is a caluaction for other cells?

"Arvi Laanemets" wrote:

Hi

=12.50/24
and format as time


Arvi Laanemets


"Kelly Thompson" wrote in message
...
My problem in 12.50 hours is 12:30, How do I get excel to convert the
first
one to the second one?

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

"Kelly Thompson" wrote:

Ok that helps alot now what is the 12.5 is a caluaction for other cells?

"Arvi Laanemets" wrote:

Hi

=12.50/24
and format as time


Arvi Laanemets


"Kelly Thompson" wrote in message
...
My problem in 12.50 hours is 12:30, How do I get excel to convert the
first
one to the second one?

Hi
format the resulting cell with the custom format
[hh]:mm

--
Regards
Frank Kabel
Frankfurt, Germany
"Kelly Thompson" schrieb im
Newsbeitrag ...
Anything over 24 hours just starts over(like 40 hours is now 16:00).
Thanks again
Kelly

"Peo Sjoblom" wrote:

Just sum the hours then convert the sum

=SUM(A1:A20)/24

format as [hh]:mm


Regards,

Peo Sjoblom

"Kelly Thompson" wrote:

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

"Kelly Thompson" wrote:

Ok that helps alot now what is the 12.5 is a caluaction for other
cells?

"Arvi Laanemets" wrote:

Hi

=12.50/24
and format as time


Arvi Laanemets


"Kelly Thompson" wrote in
message
...
My problem in 12.50 hours is 12:30, How do I get excel to convert
the
first
one to the second one?

I just Figured it out thenk you all for your help.

"Kelly Thompson" wrote:

My problem in 12.50 hours is 12:30, How do I get excel to convert the first
one to the second one?