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. |
Time function
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. |
All times are GMT +1. The time now is 09:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com