View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rick Rick is offline
external usenet poster
 
Posts: 334
Default TIME CALCULATION

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.