Times out of sequence

  • Thread starter Thread starter Jays
  • Start date Start date
J

Jays

In Access I can use the DateDiff function to calculate the difference of
time between two times and it will also show negative time! in excel I have
only been able use if(time1<time2,1+time1-time2,time1-time2). Could I
somehow use automation to access that function... ? or is there an easieer
way in excel to show negative time!

Thanks
 
Hi

If you use the 1904 date system, Tools>Options>Calculation>1904 system, then
you can display negative times.

Be aware that there is a difference of 1432 days between the 2 system's base
dates, so do not mix dates in the same workbook.
 
Maybe this for minutes..........
=(B1-A1)*24*60

or just this, for days
=B1-A1

Vaya con Dios,
Chuck, CABGx3
 
Thanks for your replies, I will keep that 1904 date system in mind, I think
I will be using the =(b1-a1)*24*60.
 
Back
Top