Time Expressions in queries

[Hammer]

Could somebody point me in the right direction with this please as I'm a bit of a novice.



I am trying to create a query to work out the number of hours worked. I have a start time & a finish time in a table, set as date / time. I have built the query but the answer does not come out as a time

Start time: 09:00
Finish time: 18:00
hours worked shows as 0.375, how do I convert this to show 9 hrs?
I've tried multiplying by 24 but i then get dates and allsort appear!!!

Many Thanks

[ssanfu]

How are you doing the calculation?

What should happen if they start at 2100 and stop the next day at 0300? You should have a date somewhere...

What you should be using is the DateDiff() function. You can have the results in seconds, minutes, hours, days, months, quarters, years, ...

BTW, 0.375 * 24 = 9 according to my calculator. (But use the DateDiff() function )

[jzwp11]

How are you currently determining the difference? Are you using the datediff() function? Does your field also include the date or just the time?

You probably want something like this:

(DateDiff("n",starttime,finishtime))/60

The above expression will give you the time in hours with the number of minutes expressed as a decimal i.e. 5.5 hours

If you want 5:30 (five hours and thirty minutes) that would require a little more manipulation of the expression.

Which do you want?

[weekend00]

when you use day1 - day2, the result is the time difference by day. in your example you got 0.375 day (9 hours)