I need a formula to calculate employees hours according to the list below. And paste the name in B4 - whatever and hours in C4. The problem is that the names and hours are continuously changing according to the schedule. So far i was able to create a macro to extract the names and hours from Sheet(Schedule) and paste them in sheet (hours) P4 and Q5.
Name Hours
Tom 6:30
Tom 6:30
Tom 8:00
Tom 7:30
Karen 8:00
Lawrence 7:30
Mary 8:00
Mary 8:00
Mary 10:30
Mary 8:00
Mary 8:00
Paul 11:00
Paul 8:00
Paul 9:00
Paul 8:00
Steven 5:30
Steven 10:30
Susan 8:00
Susan 8:00
Susan 10:30
Tara 8:00

Thanks in advance for any help.