=MROUND(C1,15/24/60)-MROUND(B1,15/24/60)

Change both "15"s to any number of minutes you want to round to.

If you get a #NAME error: ToolsAdd-ins, check Analysis Toolpak

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"yclhk" wrote in message ...
| I'd like to create a excel file to calculate the hours worked.
| Col A Col B Col C Col D
| Date Time IN Time OUT hrs worked
|
| in col B, record Time IN 7:53am
| in col C, record Time OUT 6:05pm
| However, 7:53am expects to count as 8:00am &
| 6:05pm count as 6:00pm, and hours worked results as 10 hours
|
| I wish to keep the records of the Time IN & OUT in the actual time and
| how to set the formula to calculate in form of the expected result in col D ?