Formula

Status
Not open for further replies.

Lukma

New Member
Joined
Feb 12, 2020
Messages
3
Office Version
2019, 2016
Platform
Windows
hi i need a assistance of a formula i have a start time that must start from in A1 7am only and end B1 12am in every work as Normal and any time passed 12am should show urgent in column C1 and if it fall to friday and saturday should be consider as urgent so matter the time

can anyone help with this formula

Thanks
 

mole999

Moderator
Joined
Oct 23, 2004
Messages
9,955
Office Version
2019, 2016, 2013
Platform
Windows
can you mock a table up with your expected outputs and use XL2BB to capture it and post back here
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
33,820
Office Version
365
Platform
Windows
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
 
Status
Not open for further replies.

Forum statistics

Threads
1,085,749
Messages
5,385,663
Members
401,967
Latest member
Sullivag2

Some videos you may like

This Week's Hot Topics

Top