Converting Decimal to Time

C

Charlene

I have the decimal number 12.73 and I want it to show as time, which should
be 13.13 ( 13 Hours and 13 Minutes). How do I do this?
 
C

Charlene

Maybe I'm doing this wrong. Column A reads like this

Week 1 39.00 hours
2 39.00 hours
3 39.00 hours
4 39.00 hours
5 39.00 hours
6 39.00 hours
Total 280.14 hours
Divided by 22.00 per hour
Total 12.73 hours
 
R

Ron Coderre

No, the result was 12:00:00 AM. Thank you for trying

I don't know how that could happen....Check the formula.

For A1: 12.73

B1: =(INT(A1)+(MOD(A1,1)*100/60))/(24)
B1: =(12 + 0.73*100/60)/24
B1: =(12 + 1.216666...)/24
B1: =(13.216666...)/24
B1: =0.550694444444444
(slightly more than half a day)
Formatted as time, that is 13:13:00

***********
Regards,
Ron

XL2002, WinXP-Pro
 
D

David Biddulph

Maybe I'm doing this wrong. Column A reads like this

Week 1 39.00 hours
2 39.00 hours
3 39.00 hours
4 39.00 hours
5 39.00 hours
6 39.00 hours
Total 280.14 hours
Divided by 22.00 per hour
Total 12.73 hours
Click to expand...

I'm thoroughly confused. If you've got 6 lots of 39 hours, that adds up to
234 hours, not 280.14. What does the formula in that cell say, and what
format is in that cell, and in the cells with 39.00 hours (and what does the
formula bar show where you've got 39.00 in the cell)?

But if you do end up with 280.14 and divide it by 22 to give 12.73, then
that's decimal hours, so would be 12 hours & 44 minutes, not 13 hours 13
minutes.
 
Top