Jon said:
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).
