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

How big is that grin?

--

Bob Phillips Wrote:
So you don't agree with that Bryan? <vbg

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Bryan Hessey"

wrote in message
news:Bryan.Hessey.265m1g_1144850054.3143@excelforu m-nospam.com...

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.

--


Charlene Wrote:
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

"Bob Phillips" wrote:

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)

"Charlene" wrote in message
...
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





--
Bryan Hessey

------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=532233



--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=532233