Subtracting Times with dates

T

Tstewart14

I have 4 colums on for start date one for start time one for end date and one
for end time

I need to find a formula that will give me just the difference in the two
times they may be two to 3 days different in the dates. example 3/1/2010
14:30 3/3/2010 22:30 need it to give me the answer of 56:00
 
×

מיכ×ל (מיקי) ×בידן

Assuming your 4 values are in cells A1:D1
In E1 type: =D1-B1+C1-A1
and custom format E1 as: [h]:mm
Micky
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Search using a combo box and then creating a report. 4
Check if a date comes before/after a range of dates 0
Subtracting time...again 2
How to use/create code in MS Word to calculate age? 0
How can the font and size of (all) citation numbers be altered? 1
Return column values based on criteria (HLOOKUP & VLOOKUP?) 0
number of months and days between two dates without approximation 3
Need difference in Hrs.mm.ss 3

Top