Calculating Hours

[peter_m29]

Please can anyone tell me how to work out the amount of hours and minutes between two times?

one of the functions of my database is to keep a list of attendances of children per day for a childminder. A charge needs to be calculated from the amount of hours the childminder has the child.

Is there a way to work out the hours from two time fields (i.e. TimeFrom & TimeTo) ? and if so is it possible to work out the amount of hours and minutes between a given time and the TimeFrom field (e.g. how many hours between TimeFrom and 9 o'clock - if TimeFrom = 7 then result would be 2hours 0mins)?

I have tried all sorts of ways, and im sure theres probably such a simple,obvious way to do it!

any help would be appreciated

 

[o1110010]

Please can anyone tell me how to work out the amount of hours and minutes between two times?

TimeFrom & TimeTo are date/time format? If so, =DateDiff("n",[TimeFrom],[TimeTo]) will get you the minutes between the two.

That help?

 

[peter_m29]

Thanks, The DateDiff formula is a great help!

Cheers Pat! The sample database is also very useful. Especially the first day of week function.

 

[o1110010]

Thanks, The DateDiff formula is a great help!

Cheers Pat! The sample database is also very useful. Especially the first day of week function.

You're welcome. Glad we could help out. So you got it resolved?