Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Time Calculations
In excel I want to track line efficiencies based on time. I need to know how
to subtract 1 time from another. I do not appear to have any trouble with adding times. Cell A1 Cell B1 Cell c1 Start Time End Time Hours worked 23:00 03:00 (should be 4 but all I get is hash symbols) Ideally I do not want to ann in date and times. Is there a simple formula I have not tried? |
#2
|
|||
|
|||
Hi!
Try this with the cell formatted as [h]:mm if you want the result to show as 4:00 =B2-A2+(A2B2) Try this with the cell formatted as GENERAL if you want the result to show as 4 =(B2-A2+(A2B2))*24 Biff "Paul T" <Paul wrote in message ... In excel I want to track line efficiencies based on time. I need to know how to subtract 1 time from another. I do not appear to have any trouble with adding times. Cell A1 Cell B1 Cell c1 Start Time End Time Hours worked 23:00 03:00 (should be 4 but all I get is hash symbols) Ideally I do not want to ann in date and times. Is there a simple formula I have not tried? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
time interval calculations in excel | Excel Discussion (Misc queries) | |||
Time and date calculations | Excel Worksheet Functions | |||
Time calculations & text conversions | Excel Discussion (Misc queries) | |||
Date and time calculations | Excel Discussion (Misc queries) | |||
Time Sheet calculations | Excel Worksheet Functions |