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

Please see link below for the photo.

1 — imgbb.com


You'd be my life saver because I badly needed it.

Thankyou in advance! :)
Kate
 

Some videos you may like

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying

Watch MrExcel Video

Forum statistics

Threads
1,109,013
Messages
5,526,266
Members
409,689
Latest member
martin_br

This Week's Hot Topics

Top