Nested if function with minute and time function

Closed

mikashi_96 Posts 2 Registration date Thursday January 30, 2014 Status Member Last seen January 30, 2014 - Jan 30, 2014 at 10:21 PM
mikashi_96 Posts 2 Registration date Thursday January 30, 2014 Status Member Last seen January 30, 2014 - Jan 30, 2014 at 10:22 PM

hey guys.

so i have this problem which is to write a formula to calculate the cost of minutes used in a computer shop.
here are the conditions:
< or = 15 minutes is 5.00
< or = 30 minutes is 10.00
< or = 45 minutes is 15.00
< or = 1 hour is 20.00

please help guys.. T.T

Which function will you use to enter current time in a worksheet cell?
How to enter @ in laptop - Guide
Popcorn time download - Download - Movies, series and TV
How to change time in whatsapp - Guide
Ocarina of time rom - Download - Action and adventure
Transfer data from one excel worksheet to another automatically - Guide

1 response

Answer 1 / 1

mikashi_96 Posts 2 Registration date Thursday January 30, 2014 Status Member Last seen January 30, 2014
Jan 30, 2014 at 10:22 PM

please guys i need help. thank you.

Similar discussions

How to specify macro for current active sheet

If cell A1 has text then cell B2 has today's Date

help me to add particular cells

The system time is invalid

Facebook

Similar discussions

Subscribe To Our Newsletter!