Thread: Combining Times
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jerry Mc Cauley Jerry Mc Cauley is offline
external usenet poster
 
Posts: 1
Default Combining Times

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


--
Jerry