Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Time Manipulation | Excel Discussion (Misc queries) | |||
Time Sheets | New Users to Excel | |||
A Function for Counting Since Last Time | Excel Worksheet Functions | |||
clock | Excel Worksheet Functions | |||
What function do I use to convert "time" to minutes? | Excel Worksheet Functions |