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?
Popcorn time - Download - Movies, series and TV
How to enter @ in laptop - Guide
Enter key will send your message - Guide
Transfer data from one excel worksheet to another automatically - Guide
How to change time in whatsapp - 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

trying to have the current date go into one cell (A1)

help me to add particular cells

Similar discussions

Subscribe To Our Newsletter!