Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time problem - Help please
Hi all I am currently temping for a agency and the time logging system they use is a bit dodjy to say the least. I log in using a e-trac asp system (their clock is fast by 5.43 mins ) and the logging is to the minute but the agency round the time to the closest 15mins! Can I get my exel spreadsheet to round time to the closest 15 mins e.g. 09:00 - 09:07 = 09:00 & 09:08 - 09:15 = 09:15 Help please as i lost half an hour of pay last week to this dodgy system Thanks :) -- sawagashi ------------------------------------------------------------------------ sawagashi's Profile: http://www.excelforum.com/member.php...o&userid=28883 View this thread: http://www.excelforum.com/showthread...hreadid=486320 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time problem - Help please
-- HTH RP (remove nothere from the email address if mailing direct) "sawagashi" wrote in message ... Hi all I am currently temping for a agency and the time logging system they use is a bit dodjy to say the least. I log in using a e-trac asp system (their clock is fast by 5.43 mins ) and the logging is to the minute but the agency round the time to the closest 15mins! Can I get my exel spreadsheet to round time to the closest 15 mins e.g. 09:00 - 09:07 = 09:00 & 09:08 - 09:15 = 09:15 Help please as i lost half an hour of pay last week to this dodgy system Thanks :) -- sawagashi ------------------------------------------------------------------------ sawagashi's Profile: http://www.excelforum.com/member.php...o&userid=28883 View this thread: http://www.excelforum.com/showthread...hreadid=486320 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time problem - Help please
==ROUND(A2*96,0)/96
-- HTH RP (remove nothere from the email address if mailing direct) "sawagashi" wrote in message ... Hi all I am currently temping for a agency and the time logging system they use is a bit dodjy to say the least. I log in using a e-trac asp system (their clock is fast by 5.43 mins ) and the logging is to the minute but the agency round the time to the closest 15mins! Can I get my exel spreadsheet to round time to the closest 15 mins e.g. 09:00 - 09:07 = 09:00 & 09:08 - 09:15 = 09:15 Help please as i lost half an hour of pay last week to this dodgy system Thanks :) -- sawagashi ------------------------------------------------------------------------ sawagashi's Profile: http://www.excelforum.com/member.php...o&userid=28883 View this thread: http://www.excelforum.com/showthread...hreadid=486320 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time problem - Help please
Oh, and format as time.
-- HTH RP (remove nothere from the email address if mailing direct) "sawagashi" wrote in message ... Hi all I am currently temping for a agency and the time logging system they use is a bit dodjy to say the least. I log in using a e-trac asp system (their clock is fast by 5.43 mins ) and the logging is to the minute but the agency round the time to the closest 15mins! Can I get my exel spreadsheet to round time to the closest 15 mins e.g. 09:00 - 09:07 = 09:00 & 09:08 - 09:15 = 09:15 Help please as i lost half an hour of pay last week to this dodgy system Thanks :) -- sawagashi ------------------------------------------------------------------------ sawagashi's Profile: http://www.excelforum.com/member.php...o&userid=28883 View this thread: http://www.excelforum.com/showthread...hreadid=486320 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time problem - Help please
Thanks Works great! :) :) :) :) -- sawagashi ------------------------------------------------------------------------ sawagashi's Profile: http://www.excelforum.com/member.php...o&userid=28883 View this thread: http://www.excelforum.com/showthread...hreadid=486320 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time problem - Help please
Okay Bob, I'll confess, I was trying a different approach (much more complicated) and I don't understand where the "96" in your formula comes from. Can you enlighten me? -- neopolitan ------------------------------------------------------------------------ neopolitan's Profile: http://www.excelforum.com/member.php...nfo&userid=611 View this thread: http://www.excelforum.com/showthread...hreadid=486320 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time problem - Help please
"neopolitan" wrote: Okay Bob, I'll confess, I was trying a different approach (much more complicated) and I don't understand where the "96" in your formula comes from. Can you enlighten me? I suppose youv'e worked it out, but 24 hours times 4 quarters (24*4) = 96 Regards Peter -- neopolitan ------------------------------------------------------------------------ neopolitan's Profile: http://www.excelforum.com/member.php...nfo&userid=611 View this thread: http://www.excelforum.com/showthread...hreadid=486320 |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time problem - Help please
Time is held as a fraction of a day, so to round to an hour, we multiply by
24, to a half-hour by 48 (24*2), to a quarter-hour by 96 (24*4). This number is rounded, and then divided by the original multiplier to get it back to the same scale as starting at. -- HTH RP (remove nothere from the email address if mailing direct) "neopolitan" wrote in message ... Okay Bob, I'll confess, I was trying a different approach (much more complicated) and I don't understand where the "96" in your formula comes from. Can you enlighten me? -- neopolitan ------------------------------------------------------------------------ neopolitan's Profile: http://www.excelforum.com/member.php...nfo&userid=611 View this thread: http://www.excelforum.com/showthread...hreadid=486320 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using VLOOKUP with a Date and Time | Excel Discussion (Misc queries) | |||
Date & Time problem | Excel Worksheet Functions | |||
1/0/1900 10:18:48 AM Time problem | Excel Worksheet Functions | |||
Time Sheets | New Users to Excel | |||
Problem with time calc | Excel Worksheet Functions |