christian wrote:

Hi all,

I'm creating a TimeSheet Database, I need to calculate how many hours

the Employee works.The problem is that when they enter the time, it

doesn't calculate the minutes, it just calculate hours.it rounds up to

6 and not 5:30.

I'm using this formula:

Me.Hours = (DateDiff("h", Me.Start, Me.Stop))

Ex:

Start Stop Hours

08:30AM 02:00PM 6 <it should be 5 hours and half

I would be grateful, if someone can help me.

Thanks in advanced.

If you are assured the times won't exceed 23 hours and 59 minutes you can

use the timeserial() function

? Format(timeserial(0,90,0),"hh:mm")

this will echo 01:30 The 90 is the number of minutes. If it exceeds the

largest part of time, it does the calcs for you. 90 minutes exceeds 59

minutes to it calcs the hour and minutes.

If you are using numbers, you can subtract. If using times, use

datediff() and calc on minutes.

Please read on-line help for examples on all of the functions I, and

others, have provided you.