|
Converting decimal to time
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 |
Converting decimal to time
Divide by 24 and format as time.
However, 12.73 hours is 12:43:48 -- Kind regards, Niek Otten "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 |
Converting decimal to time
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 |
Converting decimal to time
12:43:48 is a time, I want hours
"Niek Otten" wrote: Divide by 24 and format as time. However, 12.73 hours is 12:43:48 -- Kind regards, Niek Otten "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 |
Converting decimal to time
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 |
Converting decimal to time
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 |
Converting decimal to time
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 |
Converting decimal to time
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 |
Converting decimal to time
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 |
Converting decimal to time
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 |
Converting decimal to time
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 |
Converting decimal to time
12 hours, 43 minutes and 48 seconds
-- Kind regards, Niek Otten "Charlene" wrote in message ... 12:43:48 is a time, I want hours "Niek Otten" wrote: Divide by 24 and format as time. However, 12.73 hours is 12:43:48 -- Kind regards, Niek Otten "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 |
Converting decimal to time
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). -- Kind regards, Niek Otten "Charlene" wrote in message ... 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 |
Converting decimal to time
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 |
Converting decimal to time
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 |
Converting decimal to time
I was referring to the fact you (or your server) posted that response 5
times Bob "Bryan Hessey" wrote in message news:Bryan.Hessey.266l3m_1144895101.3286@excelforu m-nospam.com... 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 |
Converting decimal to time
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. -- Bob Phillips Wrote: I was referring to the fact you (or your server) posted that response 5 times Bob "Bryan Hessey" wrote in message news:Bryan.Hessey.266l3m_1144895101.3286@excelforu m-nospam.com... 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 -- 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 |
Converting decimal to time
There are 6 now <g
-- Peo "Bryan Hessey" wrote in message news:Bryan.Hessey.26705a_1144914601.3049@excelforu m-nospam.com... 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. -- Bob Phillips Wrote: I was referring to the fact you (or your server) posted that response 5 times Bob "Bryan Hessey" wrote in message news:Bryan.Hessey.266l3m_1144895101.3286@excelforu m-nospam.com... 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 -- 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 |
| All times are GMT +1. The time now is 05:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com