View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ap1971 ap1971 is offline
external usenet poster
 
Posts: 7
Default Time Calculation

Ok. Calculating a time sheet. Entries are as follows

Columns DEFG Have Time In, Time Out, Time In, Time Out headings. I
calculated total hours by: =(E5-D5)+(G5-F5) Have cell formatted as h:mm so
the time displays actual hours and minutes worked ex: 8:13 (8 Hours/13
Minutes). Now to that number I want to add additional time such as Sick
Leave 1 (hour), 1.5, .25. How can I calculate. If necessary I probably can
divide the additional time entrys into two cells with hours in one and
minutes in another. If you can help with calculation and cell formatting,
I would appreciate it.