Time Button re-visited

  • Thread starter Thread starter DaveB
  • Start date Start date
D

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
 
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.
 
Back
Top