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). |
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). |
All times are GMT +1. The time now is 04:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com