Another approach, brought By Norman Harker sometimes ago:
=ROUND((D2)/"00:15:00";0)*"00:15:00"
P.S.- don't forget, in both cases, to format the cell as Time hh:mm
Regards
--
JRod
Microsoft MVP - Excel
http://EXCELer.blogspot.com
"JRod" escreveu na mensagem
...
Suppose that the result is in D2. Try the formula:
=INT(D2*1440/15+0.4999)/1440*15
--
JRod
Microsoft MVP - Excel
http://EXCELer.blogspot.com
"CRobey4393"
escreveu na mensagem
...
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