Times out of sequence

[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

 

[Roger Govier]

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.

 

[CLR]

Maybe this for minutes..........
=(B1-A1)*24*60

or just this, for days
=B1-A1

Vaya con Dios,
Chuck, CABGx3

 

[Rick Rothstein \(MVP - VB\)]

What format do you want your difference in times to look like?

Rick

 

[Jays]

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