How do I set up a formula on a time sheet to calculate time in 1/.
 

I am setting up a time spreadsheet and I want all of my totals to be
calculated in 1/4 increments.

Example:
IN OUT IN OUT TOTAL
7:01 AM 11:47AM 12:50 PM 4:32 PM = 8:30 hours

Don't know what you total formula is, but let us say it is

=(B2-A2)+(D2-C2)

If you want to round this to the nearest quarter hour use

=ROUND(((B2-A2)+(D2-C2))*96,0)/96

If you want to round up a quarter hour, use

=ROUNDUP(((B2-A2)+(D2-C2))*96,0)/96

--

HTH

RP
(remove nothere from the email address if mailing direct)


"gschmid" wrote in message
...
I am setting up a time spreadsheet and I want all of my totals to be
calculated in 1/4 increments.

Example:
IN OUT IN OUT TOTAL
7:01 AM 11:47AM 12:50 PM 4:32 PM = 8:30 hours

Just another way:

=CEILING(B2-A2+D2-C2, 1/96)

In article ,
"Bob Phillips" wrote:

If you want to round up a quarter hour, use

=ROUNDUP(((B2-A2)+(D2-C2))*96,0)/96