More than 24 hours

[teeth]

I am creating a database to generate monthly timesheets and most employees work more than 24 hours in a month. I have time in / time out. and a field that calulates the difference. Can i convert the difference into a 'number' and then use the number to caluclate the number of hours and then the number of minutes. Employees only ever work in multiples of 15, 30, 45 and 60 minutes. I have had no experience of 'code'. Please help, ask me for more information if you need before you help me.

Many thanks
Chris B

 

[Frink]

Hallo,

That would depend whether you are using date/time data types or just numbers. I'll guess just numbers, and I'll assume that they enter the data in decimal hours, ie. 25.5 is 25 hours, 30 minutes

Try:

Dim dblDiff as double
dim intHours as integer
dim intMinutes as integer

dblDiff = val(Nz(me!txtDifference,0))
intHours = int(dblDiff)
intMinutes = 60*(dblDiff-intHours)

That might work,

- Frink