Breakdown of Date and Time stamp

Hello,

I would like to get a breakdown of the time stamp shown below.
If there's any easier and solid way to do this please let me know.

Sample Table start end.JPG

I have attached the file for better reference.

Hi,

See attached, pay special attention to Cell formatting for Columns C, D, E, and F for the results to show properly.

Thank you Sir!

You're welcome, thanks for the feedback.