g24 = 1.5
=(E25+F25)-(C25+D25)+G24/24

If this post helps click Yes
---------------
Jacob Skaria


"ap1971" wrote:

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.