Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Avg Times in MOD fx using selected rows | Excel Worksheet Functions | |||
sorting multiple minimum times | Excel Discussion (Misc queries) | |||
Charting and analyzing Times' times data for trends | Excel Discussion (Misc queries) | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
SUMPRODUCT ON TIMES | Excel Worksheet Functions |