TIME PROBLEM

G-fer

Board Regular
Joined
Jul 18, 2005
Messages
192
Hi All .....

How do I get C4 to add the contents of A1, A2 and A3 when the time is between 11:00:00 and 11:00:10 and then hold the value after 11:00:10?

I've tried using LEFT,RIGHT and MID NOW() but just can't get it to work. (not the sum part, the time part)



Regards .... G-fer
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
Assuming you have 10 in A1, 0 in B1, and 11 in C1, you will obtain 10:0:11 in D1 by using this formula in D1: =A1&":"&B1&":"&C1

If you have 00 in B1, it will give 10:00:11

What, exactly, do you see in B1?
 
Upvote 0
Hi Ralph ...

Sorry, I've explained my problem badly.

I have 3 constantly changing values in A1,A2 and A3.

I'm trying to put the sum of these values into C4 at 11 o'clock in the morning. and then lock that sum into the cell for the rest of the day.

The reason I mentioned 11:00:00 and 11:00:10 is because I've noticed that if the sheet is doing another calculation at exactly 11:00, the NOW() function will "miss the mark", so I'm allowing a generous ten second spread.

G-fer.
 
Upvote 0
I believe this cannot be done using formulas, but can be done using VBA, in which I am not conversant. So, a VBA person will hopefully pick this up and solve your problem. Good luck!
 
Upvote 0
OK team ....


Thanks for your input .... I'll start searching around ...

Regards .... G'fer.
 
Upvote 0

Forum statistics

Threads
1,213,513
Messages
6,114,064
Members
448,545
Latest member
kj9

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
Back
Top