Converting decimal to time

[Guest]

An employee is purchasing vacation per pay. My spreadsheet works like this.

Week 1 Withheld $39.00
Week 2 Withheld $39.00
Week 3 Withheld $39.00
Week 4 Withheld $39.00
Week 5 Withheld $39.00
Week 6 Withheld $39.00
Week 6 Withheld $46.14
Total Withholdings $280.14
Divided by Hourly Rate $ 22.00
Time Purchased 12.73 Hours (which would be 13 hours and 13
minutes)

How do I convert the 12.73 to read 13.13

 

[Niek Otten]

Divide by 24 and format as time.

However, 12.73 hours is 12:43:48

 

[Bob Phillips]

Still don't get why 12.73 = 13:13, but anyway

=TIME(INT(A2),MOD(A2,1)*100,0)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Guest]

12:43:48 is a time, I want hours

Divide by 24 and format as time.

However, 12.73 hours is 12:43:48

 

[Guest]

I am taking 60 minutes from the .73 and adding 1 hour to the 12, making it 13
hours
The remaining .13 minutes is the difference between .73 less .60

 

[Bryan Hessey]

Charlene,

Your 12.73 hours (as shown from your calculation) is twelve and three
quarter hours, it is not twelve hours and seventy-three minutes.

To subtract 60 and leave 13 is incorrect.

--

 

[Bryan Hessey]

Charlene,

Your 12.73 hours (as shown from your calculation) is twelve and three
quarter hours, it is not twelve hours and seventy-three minutes.

To subtract 60 and leave 13 is incorrect.

--

 

[Bryan Hessey]

Charlene,

Your 12.73 hours (as shown from your calculation) is twelve and three
quarter hours, it is not twelve hours and seventy-three minutes.

To subtract 60 and leave 13 is incorrect.

--

 

[Bryan Hessey]

Charlene,

Your 12.73 hours (as shown from your calculation) is twelve and three
quarter hours, it is not twelve hours and seventy-three minutes.

To subtract 60 and leave 13 is incorrect.

--

 

[Bryan Hessey]

Charlene,

Your 12.73 hours (as shown from your calculation) is twelve and three
quarter hours, it is not twelve hours and seventy-three minutes.

To subtract 60 and leave 13 is incorrect.

--

 

[Bryan Hessey]

Charlene,

Your 12.73 hours (as shown from your calculation) is twelve and three
quarter hours, it is not twelve hours and seventy-three minutes.

To subtract 60 and leave 13 is incorrect.

--

 

[Niek Otten]

12 hours, 43 minutes and 48 seconds

 

[Niek Otten]

You can't do that (of course you can, but it gives you wrong results).

..25 hours, 1/4 of an hour, is 15 minutes.
..73 hours is almost 3/4 of an hour, almost 45 minutes.
To be more precise, it is 43 minutes and 48 seconds.

You can easily see that if your result was more than 13, the original (280.14) would have to be more than 286 (22*13).

 

[Bob Phillips]

So you don't agree with that Bryan? <vbg>

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Bryan Hessey" <[email protected]>
wrote in message

 

[Bryan Hessey]

Apparently not, the 'three quarters' was, of course, an approximation.

How big is that grin?

--

 

[Bob Phillips]

I was referring to the fact you (or your server) posted that response 5
times

Bob

"Bryan Hessey" <[email protected]>
wrote in message

 

[Bryan Hessey]

Aaha, I only saw 3, and removed two, that was about the same time as
Niek Otten double posted a reply.
No idea what happened, the post 'hung' and eventually timed the
receiving server out, and when connection was next possible (10 minutes
later) there were 3 from me.

--

 

[Peo Sjobom]

There are 6 now <g>

--

Peo

"Bryan Hessey" <[email protected]>
wrote in message