+ Reply to Thread
Results 1 to 2 of 2

rounding time

  1. #1
    Registered User
    Join Date
    09-27-2007
    Posts
    1

    rounding time

    I am still trying to come up with a formula that will round the time if you punch in or out 6 minutes before the hour or six minutes after the hour example you punch in or out at 8:24 That's 8:30 if you punch in or out after 8:36 that's 8:30 anything after the 6 minutes or before the 6 minutes is the real time. example 8:23 is 8:23 or 8:37 is 8:37
    Please email and I can send you the timecard spreadsheet that I need it to work with.

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    Should this happen on every half hour, i.e. 09:04 rounds to 09:00 but 09:07 remains as 09:07? If so, with time in A1 try

    =IF(ROUND(ABS(ROUND(A10*48,0)/48-A10),6)<=0.004167,ROUND(A10*48,0)/48,A10)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1