Excel

Resolved · Low Priority · Version 2007

Fri 11 Jul 2008, 15:44 Delegate Nadia said...

Nadia has attended:
Excel Introduction course

Excel

Can you autofill with am/pm timings etc? Or is there a formula to add this to timings?

Fri 11 Jul 2008, 16:33 Edited on Fri 11 Jul 2008, 16:39 Trainer Pete said...

RE: Excel

Hi Nadia,

Thank you for your post, welcome to the forum, in answer to your question:

No you cannot autofill with timings only, all it will do is copy the time, you can however fill with a date and time. There is no actual formula other than the two which are commonly used =today() and =now(), changing the formatting of the cell will allow you to change how the time is applied, if you type AM/PM in the cell following your time entry it will change it from 24 to 12 hour time. If you have used the =now() function you can update this by pressing the F9 (Function 9) key.

I hope that has been of assistance. regards Pete

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Creating a range of monthly payments as text

You could use a formula to create a range of payment ie. payment amount for x% to y% rate with fixed terms and principle.

The text that would be "between Xamount and Yamount".

Here is how to do it.

1 Use the PMT function to get your monthly payments figure or whatever frequency of payments that you choose he start range.

See PMT under Excel Help

2. Nest these in the ROUND function to round decimals see ROUND under Excel Help

3. Concatenate this using "&" and concatenate " to " and concatenate "Between ".

4. Concatenate the above to PMT function for the end range

ie.

="Between "&ROUND((PMT1),decimal places)&" and "&ROUND((PMT2),decimal places)