=ROUND(((D6-C6)+(F6-E6))*96,0)/4
Times in Excel are just fractions of a day, so you'd normally multiply by 24
to convert a time (or a time difference) to a number of hours. Multiply by
another 4, round, and divide by 4 to get the nearest quarter-hour.
HTH. --Bruce

"CRobey4393" wrote:


Hi, My name is Chuck and I am trying to write a spreadsheet to be used
as a daily timesheet.

The way it is set is: c6 is Time In, d6 Time out for Lunch, e6 Time in
from lunch and f6 is Time Out.

The formula I am using for total time is (d6-c6)+(f6-e6)

I need to round this to the 1/4 hour.

Any help is appreciated.
Chuck


--
CRobey4393
------------------------------------------------------------------------
CRobey4393's Profile: http://www.excelforum.com/member.php...o&userid=28257
View this thread: http://www.excelforum.com/showthread...hreadid=478463