Time Clock Calculations

[PeterCole]

I am trying to design a time clock. I need some help defining the necessary calculations to show the differenc between two times in the correct format (For example: In at 9, out at 5 fifteen should equal 8.25 .... but right now our formula returns 8.15 which is in essence correct in the sense that it is saying a quarter of an hour in 24hr time)

Right now we are using a timetotext(IN) and timetotext(OUT) formula.

Is there a proper way to do this sort of thing?

Any suggestions would be greatly appreciated.

Cheers,

Peter

[LiveOak]

Use the functions Hour(time) and Minute(time) to separate the component parts. Minutes can be turned into decimal hours by dividing by 60.

DecimalTime = Hour(time) + Minute(time)/60

-bd