Need to add a specific time to the TODAY() function?

[Wabby]

Is this at all possible?

I have a cell that is referenced and I require to add a time to it, so the updates happen everyday at a certain time.

Cheers

[teylyn]

So, say, you want to add 2:15pm to TODAY(). You could use

=TODAY()+TIME(14,15,00)

Or, if you have the time value for 2:15pm stored in a cell, say A1, use

=TODAY()+A1

hth

[scaffdog845]

Are you trying to trigger an update event at a specific time everyday?

[Wabby]

Are you trying to trigger an update event at a specific time everyday?

Yes I am.

I think I am on the right tracks with the other reply's help - hopefully