Difference between 2 times and dates

S

Stefan Buijs

Hello,

The following problem we have to deal with:

On a sheet we have at cell A1 date number one and cell B1 time in the format
(hh:mm) and at cell A2 date number two en cell B2 time in the format
(hh:mm).
Now we have to calculate the time difference between date en time 1 and 2 in
cell C1.

How can I get this done?
 
G

Guest

Hi

Try:
=(A2+B2)-(A1+B1)
If you want the result as hours and minutes, format the cell as [h]:mm
 

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

Difference between 2 times and dates 2
Difference between date and time 7
Difference between 2 dates&time(format 0000), and excludes weekend 1
How to get timein hh:mm format 3
Difference between NOW() and TODAY() 9
Difference between two date/time values 5
converting to time format 6
Calculate elapsed time excluding specific timeframe 10

Top