Convert General Number to Time ???

  • Thread starter Thread starter Jan
  • Start date Start date
J

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...
 
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.
 
And what function would that be???

The time cards use DATE/TIME - Short Time and the other is
NUMBER - General Number.
 
Here is an attempt using the immediate window. Is this what you're after?

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