Combining Times

[Guest]

Good evening all

I am working with an employee schedule, that we are in the process of
importing into Access. Whom ever made the excel sheet (10 million years ago)
put the schedule on 3 different rows

Emp Number Start Time
End Time
Hours worked
The times have been formated to show "Short Time"

I would like to combine the time up into a single line like:

Emp Number 07:00-16:30

Is there any way to do this without retyping the entire mess?????

Thanks

 

[Guest]

Try this formula, assuming B1 and B2 are your Start Time and End Time:

=TEXT(B1,"h:mm")&" - "&TEXT(B2,"h:mm")

HTH,
Elkar

 

[Guest]

From your posting I assume A1 has the ID
B1 has the start time
B2 has the end time
B3 has the time difference


In E1 put:
=INDIRECT("A" & ROW()*3-2)
In F1 put:
=INDIRECT("B" & ROW()*3-2)
In G1 put:
=INDIRECT("B" & ROW()*3-1)
In H1 put:
=INDIRECT("B" & ROW()*3)


E1 thru H1 should be the first record.

Copy E1 thru H1 and past down as far as you need.