Time calculations

[waylander32]

Can some one help please

I have 3 times
Start time
finish time
Downtime

I need to calculate the total hours and minutes that the machine is running for
IE (start time - finish time )-downtime as it needs to calculate for a number of machines the total time will go over 24hrs which is why I can't just do the basic calculation

I have tried the datediff function but will only accept 2 dates

I need the answer to be in hours and minutes,or just minutes so that I can do a eficiency calculation
thanks in advance

 

[jal]

Huh? 3 times?

Start time (say 5 pm)
finish time (say 6 pm)
Downtime (say 7 pm) ????

Maybe what you mean is two times, plus one quantity of time (i.e. amount of downtime). Your total time would then be the DateDiff (from start to finish) in minutes minus your downtime in minutes. You can use the minus sign to subtract downtime minutes.

 

[waylander32]

Thanks for the reply

yes the downtime is a quantity of time

As it's not me using the dadabase is there a way to convert 1.20( 1hr 20min) to 80mins

if theres not then I'll just have to make sure the forms they use to collate the data are fool proof

 

[Dairy Farmer]

(Int([Field1])*60)+(([Field1]-Int([Field1]))*100)

Take the full hours and make them minutes (x60)
Take the decimal minutes and make them minutes (x100)
Add the two together.

Int([Field1]) = Full hours
[Field1]-Int([Field1]) = Remainder after number is divided by a full hour, i.e minutes in decimal format

 

[waylander32]

Thanks for the help
will test and let you know

 

[namliam]

Check out this thread:
http://www.access-programmers.co.uk/forums/showthread.php?t=200459

format( Int(24*sum( Timesum)), "0") & format( sum(Timesum) , ":nn:ss" )