Time and Date

D

Dastard

well i have data like this in four cells

date1 time1 date2 time2

this data is in different cells . is it possible that i can have some
formula which could actually count the difference between two times ..
in hours/minutes/seconds .. considering the date aswell since time1 is
on date1 and time2 is on date2 .. so all i need is the duration
inbetween time1 and time2

Regards
 
A

ADG

Hi Dastard

If your data is in A1 to D1 the below will give you whole days

=INT(((A1+B1)-(C1+D1)))

and the below will give the hours (remenber to format this cell for time)

=MOD(((A1+B1)-(C1+D1)),1)
 
B

Bob Phillips

Use =C1-A1-B1+D1 and format the cell as [h]:mm:ss

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

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

Top