Time Problems

[Sockpuppet]

Hello,

Working on a database at work...unfortunatly I can't redesign the
source data like I'd want it.

I have to work out the hours a driver has worked from date, start time
and finish time. This is great if he does 9am - 5pm however if he goes
over 00:00 and finishes in the morning then it fails to work it out.

At the moment I have:

=IIf([Start Work]>[Finish Work],(([ValMidnight]-[Start Work])+[Finish
Work])*24,(([Finish Work]-[Start Work])-[Total Breaks])*24)

The val midnight is a text box I have hidden with 23:59:59 as a time in
there to simulate midnight so working out everything to midnight and
then what was worked over. This however produces #Error when put into a
report.

Any ideas?

Cheers
Richard

[Sockpuppet]

Sorted it now.

For reference I used:

Hours Worked: IIf([Start Work]>[Finish
Work],(TimeValue("23:59:59")-[Start Work])+[Finish
Work]+TimeValue("00:00:01"),([Finish Work]-[Start Work])-IIf([Total
Breaks]<>0,[Total Breaks],0))*24

The second TimeValue() is to make the rounding easier so that it is not
displaying .99999 of an hour.

[paii, Ron]

Assuming [Start Work] and [Finish Work] are date fields and contain the date
worked why not use datediff("s",[Finish Work],[Start Work]) which will
return number of seconds.

"Sockpuppet" <ri*****@firebadger.net> wrote in message
news:11**********************@m73g2000cwd.googlegr oups.com...

Sorted it now.

For reference I used:

Hours Worked: IIf([Start Work]>[Finish
Work],(TimeValue("23:59:59")-[Start Work])+[Finish
Work]+TimeValue("00:00:01"),([Finish Work]-[Start Work])-IIf([Total
Breaks]<>0,[Total Breaks],0))*24

The second TimeValue() is to make the rounding easier so that it is not
displaying .99999 of an hour.