add time 1

[tatika]

Hope someone could help me.
My goal is to calculate the number of hours a person works in a day. I have two fields "Logon" and "Logout" as medium time. I would like to calculate the logon and out to a number. Example: if I logon at 10:00 am and logout at 3:00 pm it should give me a total of 5 hours for the day.
Any suggestions?

Thanks in advance

 

[PHV]

Have you tried something like this ?
Format(Logout - Login, "hh:mm")

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[tatika]

thanks so much for the great help

 

[lespaul]

However, this will only work as long as the time does not exceed 23 hours 59 minutes 59 seconds. So as long as you are not trying to track machine time over a long period, this will work, but if you are trying to work with long periods of time you will have to find a different solution.
HTH

Leslie