View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default calculate difffernce in time in attendane eg 0830 - 1750

=(end_time-start_time)*24

and format as general

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Fabricare" wrote in message
...
How do I calculate time difference in hours in my attendance records, eg

0850
to 1950