Jump to content
I will no longer be developing resources for Invision Community Suite ×
By fans, for fans. By fans, for fans. By fans, for fans.

Excel Help

Guest Kev

By Guest Kev
in The Swanny

 Share

Recommended Posts

Guest Kev

Guest Kev

Posted
Posted

What I would like is the formula for this.

 

1) All cells are blank.

 

2) I place the time 15:00 in cell A1

 

3) I then want cell A3 to show 14:30, A4 to show 14:35, A5 to show 14:40 etc etc upto Cell A12 were it will show 15:15.

 

Now I've got the formula to do this for Cell A3 =SUM(A1)-(0.0205) and the others.

 

But what I need is the extra bit that if there is no value in placed in Cell A1 then all the other cells are blank.

 

Is this clear ?

Guest Kev

Guest Kev

Posted
Posted

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

Guest Kev

Guest Kev

Posted
Posted

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing

  • Recently Browsing   0 members

    • No registered users viewing this page.

Home

Notifications

PMs
×
×
  • Create New...