Convert General Number to Time ???

[Jan]

Need to compare hours tracked by employees punching in and
out with time cards that show HH:MM and their hand-written
timsheets that are and have been submitted as a whole
number and decimal method (8.5 hours). All of this
information has already be input so now I need to know how
to convert the general number to time. Is that possible
without having to rekey everything?

Time In = 7:04 am
Time Out = 15:00 pm
Log = 7.5 hours

Their actual time is 7 hours and 56 minutes and their
posted hours are 7 hours and 30 minutes -- with a 26-
minute difference. I also need to subtract for a 30-
minute lunch. In this instance, it should show a negative
4 minutes.

Thank you...

 

[Chris]

Certainly is possible. But you will need a function to do
it. The actual code will depend on the data types of your
source data. Just be aware that using functions in queries
can slow down execution.

 

[jAN]

And what function would that be???

The time cards use DATE/TIME - Short Time and the other is
NUMBER - General Number.

 

[Wayne Morgan]

Here is an attempt using the immediate window. Is this what you're after?

?Format(7.5 / 24, "Short Time")
07:30

 

[John Spencer (MVP)]

How about

DateDiff("n",[Time In],[TimeOut]) -30 - [Log]*60