01/02/2018

Hi All I have large data set that appears like this sorted Date - Name - Code - Start - End 01/01/2018 - A - Work - 08:00 - 13:00 01/01/2018 - A - Lunch - 13:00 -13:30 01/01/2018 -A - Work - 13:30 - 16:00 01/02/2018-A - AL - 08:00 - 12:00 01/02/2018 - A- Lunch - 12:00 - 12:30 01/02/2018 - A -...

Hi Everyone I really need your help. I have a Table called TBLSJ : <colgroup><col><col><col><col></colgroup><tbody> Date Name Jump height Type of jump 01/02/2018 Player 1 54 SJ 01/02/2018 Player 1 60 Left 01/02/2018 Player 1 53 Right 05/07/2018 Player 1 46 Left 05/07/2018 Player 1...

Hi everyone I need some help. I have a table (called TBLSJ) of data which looks like this: <colgroup><col><col><col><col></colgroup><tbody> Date Name Jump height Type of jump 01/02/2018 Player 1 49 SJ 01/02/2018 Player 1 48 Left 01/02/2018 Player 1 65 Right 05/07/2018 Player 1 59...

Thought I'd repost this as the formatting did not come through correctly in the original post...apologies. One thing I did try was to use MAX and MIN on the date fields to determine number of shifts being looked at and therefore get an accurate value: =DAYS360(MIN(C3:C17),MAX(C3:C17)) It...

Morning, I need a little bit of help please. Simply, I have a start date/time and an end time/date, and I need to split out the total number of hours (or decimal days) in the range so that they are apportioned to each day that they fall in: Data: A2) arrived date/time 01/02/2018 09:00...