Times Over 24 Hours 1

[DanAuber]

I have Data for Servers showing Backup Start Time and End Time. I want to do a calculation on these to produce the length of time the backup took. If I have a backup time that is over 24hrs access (97) doesn't seem to be able to show the length correctly as a time.

Can anyone help with this please ??

Dan

Dan Auber
DanAuber@aol.com

http://members.aol.com/_ht_a/danauber/myhomepage/

 

[Eradic8or]

I would suggest here that you have four fields.
2 fields for the date and 2 fields for the time.
This way, when you do your calculations, you can concatenate the results together to display the difference.

Eradic8or

 

[MichaelRed]

Dan,

Waht function are you using to calculate the (elapsed) time? DateDiff (w/ appropiate args) DOES give the correct answer for intervals.



MichaelRed
mred@duvallgroup.com
There is never time to do it right but there is always time to do it over

 

[DanAuber]

Thanks - that sounds like what I need

Dan Auber
DanAuber@aol.com

http://members.aol.com/_ht_a/danauber/myhomepage/

 

[Eradic8or]

Does this not just give the interval in days though?

Eradic8or