Time Button re-visited

[DaveB]

I wrote in the question below at "DaveB wrote", and you
answered below at "Like having this" but when I used it,
it only put in 1.0 for the day, probably because I have
both fields set for the general date, but what I really
need it to show is the hours. How do I do this?

Like having this

Me.TotalTimeofBill = Me!CompletionDateTime - Me!
StartDateTime

in the Click event of the button?
Pavel

 

[Wayne Morgan]

Me.TotalTimeOfBill = DateDiff("h", Me!StartDateTime, Me!CompletionsDateTime)

How do you want to handle parts of hours? Usually, if you want hours, it is
better to get minutes then calculate from their hours and part of hours.