Rounding Timesheet to quarter hour

**djknight2007** · 10-19-2008, 05:32 AM

I have made a time sheet and am trying to have the total hours and grand total- round up to the nearest quarter hour, I.E. (.25, .50, .75. 00), if anyone can help me please it will greatly be appreciated, this is what i have now, in my totals fields:

ROUND(IF((OR(B13="",C13="")),0,IF((C13<B13),((C13-B13)*24)+24,(C13-B13)*G1424))+IF((OR(E13="",F13="")),0,IF((F13<E13),((F13-E13)*24)+24,(F13-E13)*24)),2)

I Have also attached the file so you can see it completely, if you can help me fix it i would really really appreciate it.

**19fortysix** · 10-19-2008, 10:30 AM

I replaced the formua you had in Column G with =ROUND(SUM((F13-B13)-(E13-C13))*96,0)/96 and it appears to work as you requested.
Hope this helps, GMc

**djknight2007** · 10-19-2008, 12:34 PM

Thank You very much Works Perfect

**19fortysix** · 10-19-2008, 12:36 PM

You're welcoome! I notice you're location is Texas - where? I'm in Spring.
GMc

**djknight2007** · 10-19-2008, 02:15 PM

am in Killeen, TX i used to live in Houston on Little York Rd. I also used to work in spring TX in a Company called Well Dynamics.

**daddylonglegs** · 10-19-2008, 03:38 PM

You don't really need SUM

If you want the times in decimal format, i.e. 8.5 rather than 8:30 then try

=ROUND((F13-B13-E13+C13)*96,0)/4

**djknight2007** · 10-20-2008, 07:42 PM

thanks daddylonglegs that works perfect ....helped alot

**GuardianTX** · 04-30-2010, 12:58 PM

Hi, I am running into a similar problem, however I am trying to transition from California Timecard management to Texas. The overtime doesnt seem to work right with this sheet. I inherited this from my predecessor.

=ROUND(IF((OR(C24="",D24="")),0,IF((D24<C24),((D24-C24)*24)+24,(D24-C24)*24))+IF((OR(F24="",G24="")),0,IF((G24<F24),((G24-F24)*24)+24,(G24-F24)*24)),2)