Current time (2002 XP)

Topic

New Reply

I need to display the current time in A1 and display the current time plus 15 minutes in B1. I have tried and failed many times so, despite my embarrassment, I am asking for help. Thank you in advance.

Reply | Quote

Replies

Hi Don,

In cell A1, enter the formula =NOW() and in cell B1, enter the formula =A1+TIME(0,15,0)
Then, select A1 and B1, and use Format | Cells… to set the desired time format for these cells.

The TIME function has syntax TIME(hours,minutes,seconds).

Reply | Quote

Don

Check this… http://www.erlandsendata.no/

and see the attached file

Reply | Quote

If you forget formulas and syntax, a very basic way is to use the excel date calculation principle, I mean that the excel date unit = one day.
So if you want to display one hour, just type =1/24 then format / cell / number / time
If you want to add 15 minutes to the current time, type =now()+(1/24/60*15)

Quick and dirty but easy to remember…

Reply | Quote