Breaking out the time from date/time

[detaylor1242]

I need to create a time tracker for work orders submitted by clients. I have the clients table built and working as well as the work order table. I am working on the "time tracker" where I need to be able to input a date that I am working on and the time started and time ended. Then calculate the total time spent on that date. I can't figure out how to get the time stamps working and then how to calculate the time.

Once the time is calculated I want to produce a report at the end of the month that will show by client the total time spent on each work order as well as the work order and individual time stamps for each time that I worked on the WO.

[Rod]

Date/time is held as a number, the integer part is a relative day number and the decimal part is the time of day. So, making sure the variable is a proper date type:

dteMyDateTime - Int(dteMyDateTime)

will give you the decimal part (i.e. the time). If you wish to display this (form or report) then use the Format function.

Hope this helps.