Auto complete formula not working in all cells

MsCynic

Board Regular
Joined
May 21, 2006
Messages
122
Hi guys, am doing some calculations involving time and for some reason, when I click on the little black square at the bottom right of the box, it doesn't always auto fill the cells below. Might it be to do with the fact that I stretched some cells because they were too narrow?

For example, I have in cell C19 the time 05-31
In Cell c20 I have this formula: =C19+TIME(0,3,0), yet when I click on the wee black square, it doesn't automatically place 05-37 in C21. Yet this does work in other cells.

Any idea how I can fix this? I'm going to use this ss as the basis for other worksheets and want to get it working as a template.

TIA
Jo
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

sunnyland

Well-known Member
Joined
Jan 27, 2006
Messages
912
Hello,

Will it have something to do with your way to enter a time?
If I enter in a cell 05-31, Excel interpret this as a date (01/01/1931)
Formatting this as a date will give me 12:00 and not 05:31.

See if it works better entering 05:31 as displayed.

05:31 should have a value of: 0.229861111111111 formatted as number

To quickly check the value of your cell : click on
Cltr + `
This is a shortcut to display formula but it also displays real value for date or time
 

Watch MrExcel Video

Forum statistics

Threads
1,133,649
Messages
5,660,113
Members
418,550
Latest member
kp_

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top