Thread: Adding hrs
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
demetri
 
Posts: n/a
Default Adding hrs

How do you make a formula that sais that an employee started work at 4am and
finished at 1030 am i need the answer to 6.5 hrs. The problem would read say
in cell a1 "0400" in cell a2 (1030) and then I want cell 3 to display the
amount of hrs as 6.5 not 6.3?