Time Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Just sum the hours then convert the sum

=SUM(A1:A20)/24

format as [hh]:mm


Regards,

Peo Sjoblom
 
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
Click to expand...
Click to expand...
 
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
 
Hi
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?
Click to expand...
Click to expand...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sort a Table into one long list 5
Best £15 Sim Deal 2
checkif/sumif question 2
HOW DO I COMBINE DATA FROM MULTIPLE ROW INTO ONE ROW AND ADD VALUE 3
Return value in 3rd column based on 2 other columns 2
help with pivot table please 4
HOW DO I COMBINE two spreadsheets into one by names in column a 3
Time conversion 1

Back
Top