software

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

Divide by 24 and format as time.

However, 12.73 hours is 12:43:48

--
Kind regards,

Niek Otten

quot;Charlenequot; gt; wrote in message ...
gt; An employee is purchasing vacation per pay. My spreadsheet works like this.
gt;
gt; Week 1 Withheld $39.00
gt; Week 2 Withheld $39.00
gt; Week 3 Withheld $39.00
gt; Week 4 Withheld $39.00
gt; Week 5 Withheld $39.00
gt; Week 6 Withheld $39.00
gt; Week 6 Withheld $46.14
gt; Total Withholdings $280.14
gt; Divided by Hourly Rate $ 22.00
gt; Time Purchased 12.73 Hours (which would be 13 hours and 13
gt; minutes)
gt;
gt; How do I convert the 12.73 to read 13.13
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)

quot;Charlenequot; gt; wrote in message
...
gt; An employee is purchasing vacation per pay. My spreadsheet works like
this.
gt;
gt; Week 1 Withheld $39.00
gt; Week 2 Withheld $39.00
gt; Week 3 Withheld $39.00
gt; Week 4 Withheld $39.00
gt; Week 5 Withheld $39.00
gt; Week 6 Withheld $39.00
gt; Week 6 Withheld $46.14
gt; Total Withholdings $280.14
gt; Divided by Hourly Rate $ 22.00
gt; Time Purchased 12.73 Hours (which would be 13 hours and 13
gt; minutes)
gt;
gt; How do I convert the 12.73 to read 13.13
12:43:48 is a time, I want hours

quot;Niek Ottenquot; wrote:

gt; Divide by 24 and format as time.
gt;
gt; However, 12.73 hours is 12:43:48
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;Charlenequot; gt; wrote in message ...
gt; gt; An employee is purchasing vacation per pay. My spreadsheet works like this.
gt; gt;
gt; gt; Week 1 Withheld $39.00
gt; gt; Week 2 Withheld $39.00
gt; gt; Week 3 Withheld $39.00
gt; gt; Week 4 Withheld $39.00
gt; gt; Week 5 Withheld $39.00
gt; gt; Week 6 Withheld $39.00
gt; gt; Week 6 Withheld $46.14
gt; gt; Total Withholdings $280.14
gt; gt; Divided by Hourly Rate $ 22.00
gt; gt; Time Purchased 12.73 Hours (which would be 13 hours and 13
gt; gt; minutes)
gt; gt;
gt; gt; How do I convert the 12.73 to read 13.13
gt;
gt;
gt;

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

quot;Bob Phillipsquot; wrote:

gt; Still don't get why 12.73 = 13:13, but anyway
gt;
gt; =TIME(INT(A2),MOD(A2,1)*100,0)
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;Charlenequot; gt; wrote in message
gt; ...
gt; gt; An employee is purchasing vacation per pay. My spreadsheet works like
gt; this.
gt; gt;
gt; gt; Week 1 Withheld $39.00
gt; gt; Week 2 Withheld $39.00
gt; gt; Week 3 Withheld $39.00
gt; gt; Week 4 Withheld $39.00
gt; gt; Week 5 Withheld $39.00
gt; gt; Week 6 Withheld $39.00
gt; gt; Week 6 Withheld $46.14
gt; gt; Total Withholdings $280.14
gt; gt; Divided by Hourly Rate $ 22.00
gt; gt; Time Purchased 12.73 Hours (which would be 13 hours and 13
gt; gt; minutes)
gt; gt;
gt; gt; How do I convert the 12.73 to read 13.13
gt;
gt;
gt;


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:
gt; I am taking 60 minutes from the .73 and adding 1 hour to the 12, making
gt; it 13
gt; hours
gt; The remaining .13 minutes is the difference between .73 less .60
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; Still don't get why 12.73 = 13:13, but anyway
gt; gt;
gt; gt; =TIME(INT(A2),MOD(A2,1)*100,0)
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;Charlenequot; gt; wrote in message
gt; gt; ...
gt; gt; gt; An employee is purchasing vacation per pay. My spreadsheet works
gt; like
gt; gt; this.
gt; gt; gt;
gt; gt; gt; Week 1 Withheld $39.00
gt; gt; gt; Week 2 Withheld $39.00
gt; gt; gt; Week 3 Withheld $39.00
gt; gt; gt; Week 4 Withheld $39.00
gt; gt; gt; Week 5 Withheld $39.00
gt; gt; gt; Week 6 Withheld $39.00
gt; gt; gt; Week 6 Withheld $46.14
gt; gt; gt; Total Withholdings $280.14
gt; gt; gt; Divided by Hourly Rate $ 22.00
gt; gt; gt; Time Purchased 12.73 Hours (which would be 13 hours
gt; and 13
gt; gt; gt; minutes)
gt; gt; gt;
gt; gt; gt; How do I convert the 12.73 to read 13.13
gt; gt;
gt; gt;
gt; gt;--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=532233
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:
gt; I am taking 60 minutes from the .73 and adding 1 hour to the 12, making
gt; it 13
gt; hours
gt; The remaining .13 minutes is the difference between .73 less .60
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; Still don't get why 12.73 = 13:13, but anyway
gt; gt;
gt; gt; =TIME(INT(A2),MOD(A2,1)*100,0)
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;Charlenequot; gt; wrote in message
gt; gt; ...
gt; gt; gt; An employee is purchasing vacation per pay. My spreadsheet works
gt; like
gt; gt; this.
gt; gt; gt;
gt; gt; gt; Week 1 Withheld $39.00
gt; gt; gt; Week 2 Withheld $39.00
gt; gt; gt; Week 3 Withheld $39.00
gt; gt; gt; Week 4 Withheld $39.00
gt; gt; gt; Week 5 Withheld $39.00
gt; gt; gt; Week 6 Withheld $39.00
gt; gt; gt; Week 6 Withheld $46.14
gt; gt; gt; Total Withholdings $280.14
gt; gt; gt; Divided by Hourly Rate $ 22.00
gt; gt; gt; Time Purchased 12.73 Hours (which would be 13 hours
gt; and 13
gt; gt; gt; minutes)
gt; gt; gt;
gt; gt; gt; How do I convert the 12.73 to read 13.13
gt; gt;
gt; gt;
gt; gt;--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=532233
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:
gt; I am taking 60 minutes from the .73 and adding 1 hour to the 12, making
gt; it 13
gt; hours
gt; The remaining .13 minutes is the difference between .73 less .60
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; Still don't get why 12.73 = 13:13, but anyway
gt; gt;
gt; gt; =TIME(INT(A2),MOD(A2,1)*100,0)
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;Charlenequot; gt; wrote in message
gt; gt; ...
gt; gt; gt; An employee is purchasing vacation per pay. My spreadsheet works
gt; like
gt; gt; this.
gt; gt; gt;
gt; gt; gt; Week 1 Withheld $39.00
gt; gt; gt; Week 2 Withheld $39.00
gt; gt; gt; Week 3 Withheld $39.00
gt; gt; gt; Week 4 Withheld $39.00
gt; gt; gt; Week 5 Withheld $39.00
gt; gt; gt; Week 6 Withheld $39.00
gt; gt; gt; Week 6 Withheld $46.14
gt; gt; gt; Total Withholdings $280.14
gt; gt; gt; Divided by Hourly Rate $ 22.00
gt; gt; gt; Time Purchased 12.73 Hours (which would be 13 hours
gt; and 13
gt; gt; gt; minutes)
gt; gt; gt;
gt; gt; gt; How do I convert the 12.73 to read 13.13
gt; gt;
gt; gt;
gt; gt;--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=532233
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:
gt; I am taking 60 minutes from the .73 and adding 1 hour to the 12, making
gt; it 13
gt; hours
gt; The remaining .13 minutes is the difference between .73 less .60
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; Still don't get why 12.73 = 13:13, but anyway
gt; gt;
gt; gt; =TIME(INT(A2),MOD(A2,1)*100,0)
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;Charlenequot; gt; wrote in message
gt; gt; ...
gt; gt; gt; An employee is purchasing vacation per pay. My spreadsheet works
gt; like
gt; gt; this.
gt; gt; gt;
gt; gt; gt; Week 1 Withheld $39.00
gt; gt; gt; Week 2 Withheld $39.00
gt; gt; gt; Week 3 Withheld $39.00
gt; gt; gt; Week 4 Withheld $39.00
gt; gt; gt; Week 5 Withheld $39.00
gt; gt; gt; Week 6 Withheld $39.00
gt; gt; gt; Week 6 Withheld $46.14
gt; gt; gt; Total Withholdings $280.14
gt; gt; gt; Divided by Hourly Rate $ 22.00
gt; gt; gt; Time Purchased 12.73 Hours (which would be 13 hours
gt; and 13
gt; gt; gt; minutes)
gt; gt; gt;
gt; gt; gt; How do I convert the 12.73 to read 13.13
gt; gt;
gt; gt;
gt; gt;--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=532233
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:
gt; I am taking 60 minutes from the .73 and adding 1 hour to the 12, making
gt; it 13
gt; hours
gt; The remaining .13 minutes is the difference between .73 less .60
gt;
gt; quot;Bob Phillipsquot; wrote:
gt;
gt; gt; Still don't get why 12.73 = 13:13, but anyway
gt; gt;
gt; gt; =TIME(INT(A2),MOD(A2,1)*100,0)
gt; gt;
gt; gt; --
gt; gt; HTH
gt; gt;
gt; gt; Bob Phillips
gt; gt;
gt; gt; (remove nothere from email address if mailing direct)
gt; gt;
gt; gt; quot;Charlenequot; gt; wrote in message
gt; gt; ...
gt; gt; gt; An employee is purchasing vacation per pay. My spreadsheet works
gt; like
gt; gt; this.
gt; gt; gt;
gt; gt; gt; Week 1 Withheld $39.00
gt; gt; gt; Week 2 Withheld $39.00
gt; gt; gt; Week 3 Withheld $39.00
gt; gt; gt; Week 4 Withheld $39.00
gt; gt; gt; Week 5 Withheld $39.00
gt; gt; gt; Week 6 Withheld $39.00
gt; gt; gt; Week 6 Withheld $46.14
gt; gt; gt; Total Withholdings $280.14
gt; gt; gt; Divided by Hourly Rate $ 22.00
gt; gt; gt; Time Purchased 12.73 Hours (which would be 13 hours
gt; and 13
gt; gt; gt; minutes)
gt; gt; gt;
gt; gt; gt; How do I convert the 12.73 to read 13.13
gt; gt;
gt; gt;
gt; gt;--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: www.excelforum.com/member.php...oamp;userid=21059
View this thread: www.excelforum.com/showthread...hreadid=532233