How to calculate the Time gaps between meetings during the day

  • Thread starter Thread starter khattabcosmology
  • Start date Start date
K

khattabcosmology

Guest
Good Evening, if I have the schedule of meeting during Monday as follows:

StartTime 1 : 08:00:00

EndTime 1 : 10:00:00

StartTime 2: 09:00:00

EndTime 2 : 10:30:00


I'd like to calculate the gaps in time during the day and get the results as follows:

Start gap time 1= 00:00:00

End gap time 1= 07:59:59


Start gap time 2 = 10:30:01

End gap time 2 = 23:59:59


Taking into account the intersection between meeting times

Please, help

Continue reading...
 
Back
Top