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
"Tim" wrote in message
...
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.