Notifications
Clear all
Topic starter
HI This is my first post.
I have a spreadsheet that has the shift times of team members as attached (left side). I am wondering if a formula can be written so it would read the start and finish times and convert it into the format as shown on the right hand side in the box.
Hope I have created this correctly. Thanks very much for your consideration.
Regards
Phil
Posted : 16/11/2018 4:57 pm
Hi Philip
Please refer attachment.
Sunny
Posted : 16/11/2018 7:21 pm
Topic starter
Hi Sunny,
Thank you very much.
All the best
Phil
Posted : 17/11/2018 8:00 am
No problem.
Glad I was able to help.
Sunny
Posted : 17/11/2018 11:15 am
