Thread: Time problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default 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).