Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Time problem
I would like to create a formula that does the following:
A2 - Time from B2 - Time to C2 - Break duration (mins, hours) D2 = A2 - B2 - C2 The problem is that I can't find a way to subtract the duration (C2). |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Time problem
"Jon" wrote:
I would like to create a formula that does the following: A2 - Time from B2 - Time to C2 - Break duration (mins, hours) D2 = A2 - B2 - C2 That should be B2 - A2 - C2, assuming that "time from" is start time and "time to" is end time. The problem is that I can't find a way to subtract the duration (C2). If everything is entered in consistent units, it should be straight-forward. Unfortunately, you neglect to say how the numbers in A2, B2 and C2 are entered. Always provide a complete numerical example, show formulas exactly as they are entered (copy-and-paste), show the results you get, and explain what results you want, using the numerical example. For example: A2: May 31, 2009 1:00 pm B2: Jun 1, 2009 1:00 am C2: 1:30 D2: =B2-A2-C2 When you format D2 with Custom format [h]:mm, the result is displayed as 10:30 (10h 30m). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Problem | Excel Worksheet Functions | |||
Time Function Problem | Excel Worksheet Functions | |||
Time problem - Help please | Excel Discussion (Misc queries) | |||
Time Problem | Excel Discussion (Misc queries) | |||
Problem with time calc | Excel Worksheet Functions |