Thread: Time function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tim
 
Posts: n/a
Default 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.