converting time

[Floyd Forbes]

How do I convert 6:59 AM timein and 6:41 PM timeout to 11.70 decimal time?

Thanks

 

[Rob Parker]

DateDiff("n",[TimeIn],[TimeOut])/60

Rob

 

[Larry Linson]

"Floyd Forbes" wrote

How do I convert 6:59 AM timein and 6:41 PM timeout to 11.70 decimal

time?

Use the DateDiff function to subtract the timein value from the timeout
value and get the answer in seconds. Then divide that result by 3600, the
number of seconds in an hour, and you'll have the answer you want. Be sure
you do the final calculations using Floating Point variables, so you will
get the decimal fractional part.

Larry Linson
Microsoft Access MVP

 

[Floyd Forbes]

Thanks

DateDiff("n",[TimeIn],[TimeOut])/60

Rob

How do I convert 6:59 AM timein and 6:41 PM timeout to 11.70 decimal
time?

Thanks

 

[Floyd Forbes]

Thanks

"Floyd Forbes" wrote

time?

Use the DateDiff function to subtract the timein value from the timeout
value and get the answer in seconds. Then divide that result by 3600, the
number of seconds in an hour, and you'll have the answer you want. Be
sure you do the final calculations using Floating Point variables, so you
will get the decimal fractional part.

Larry Linson
Microsoft Access MVP