=B1-A1+D1-C1
Format the result cell as [h]:mm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"RICK" wrote in message ...
| Can some please tell me the formula on how to calculate hours worked. For
| example IN 6:15AM OUT 12:30PM IN 1:00PM OUT 6:00PM. I FOUND THERE IS A
| SIMILAR ANSWER HERE THAT CAME FROM LARRY, BUT WHEN I TYPE THE FORMULA THAT HE
| PROVIDED IT DOES'NT CALCULATE TO TOTAL HOURS ALTHOUGH I ALREADY FORMATED CELL
| A TO D TO h:mm and CELL E FORMATED TO NUMBER WITH 1 DEC... ALSO SHOULD THERE
| BE AN hh:mm or just an h:mm?
| PLEASE HELP.