Time function

T

Tim

Hello All

I have a work sheet (invoice) that I would like to use to calculate hours on
various projects. I have a time-in, and time-out column. I would like to
calculate hours spent. My formula returns the time in hrs and min. I would
like just hrs.

i.e. It now returns 7:30 for 7 hrs and 30min. I would like it in the form
of 7.5.

Thanks in advance for your help.
 
C

Chip Pearson

Times are stored as fractions of a 24-hour day (6:00 = 0.25,
12:00 = 0.5, 18:00 = 0.75, etc). Multiply your time result by 24
to get the decimal number of hours. E.g.,

=(time_out - time_in)*24


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Top