Time and Date



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



Hi Dastard

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


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


Bob Phillips

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


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