Reversed Gantt Chart Formulas

kateprocopio

New Member
Joined
Aug 10, 2017
Messages
3
Hi everyone,

I am currently creating an employee scheduler using a Reversed Gantt Chart, one where the user plots the schedule in the chart then the START and END details are automatically updated (using formulas) while plotting.

I used legends such as 0 - vacant hours, 1 - working hours, 2 - break hours.

The following columns requires formula: START TIME, END TIME, START OF BREAK HOURS TIME, LENGTH OF BREAK HOURS


I tried attaching a photo, hope it appears.
You'd be my life saver because I badly needed it.

Thankyou in advance!
 

Some videos you may like

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

Watch MrExcel Video

Forum statistics

Threads
1,108,768
Messages
5,524,787
Members
409,600
Latest member
Dunnowhatfor

This Week's Hot Topics

Top