Same question again. Didn't get answered yet.

[DaveB]

Am I not asking the question so that you can understand
it or what? No one has answered my question today or
yesterday. Do I need to rephrase the question?

Earlier 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

 

[Duane Hookom]

What is the data type of TotalTimeOfBill?
Are you storing StartDateTime, CompletionDateTime, and TotalTimeOfBill all
in the same record?
If so, why?
Pavel provided a good answer. What don't you understand about his solution?
His answer is in units of days. If you need hours, then check out the
DateDiff() function. You also need to determine if you just want whole hours
or hours with decimals.

 

[Randy Harris]

It might be worth your while to simply ask the question. Your message looks
as though you already engaged in a dialog with someone. It isn't very clear
what you are trying to accomplish or what you mean by "Like having this".

 

[George Nicholson]

it only put in 1.0 for the day, probably because I have

both fields set for the general date

You mention 3 fields. Which "both" fields of those three are you referring
to?
A GeneralDate format would display the number 1 as "1/1/1900 12:00 AM" (or
something similar, depending on your regional settings).
You would *NOT* see a result of 1 displayed if the result is formatted as a
Date or Time.
Therefore, what exactly are you trying to do? Convert values? IN WHAT WAY is
the answer you got incorrect: What were your CompletionDateTime and
StartDateTime values, what value *DO* you expect to see as a result?