Calculate price from a matrix for daytime, night and weekend

parolisa

New member
Joined
Jan 27, 2013
Messages
1
Reaction score
0
Points
0
Hello,

I need someones help to write a formula to calculate hourly rates from a price matrix for different areas at daytime, night and weekend.

Please see a detailed, short description of the issue in the attached file.

Maximum working hours is from 7:00 AM to 11:59 PM.

I have tried for hours now I need help from an excelgur!

Best
ParolisaView attachment Calculate total price from time and matrix.xlsx
 
Back
Top