Time function
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.
|