Adding minutes to Now() problem...

  • Thread starter Thread starter Pete Baugh
  • Start date Start date
P

Pete Baugh

Hi,
I currently have a problem regarding adding times.

Situation is this, I have a column with numbers representing minutes,
and another column that I want to display the current date and time
PLUS those minutes.
eg
If todays date and time is 13/07/2004 13:52, and I have 3000 in my
minutes column, then i want my target cell to read 15/07/2004 15:52
However I'm using =NOW()+TIME(0,F4,0) and this is giving me 13/07/2004
15:52. So it's ignoring the days.... Is it something to do with
formatting or is my formula the wrong one for what I am trying to
achieve???

Many thanks in advance!

Pete Baugh
Recoilsoft Ltd
 
However I'm using =NOW()+TIME(0,F4,0) and this is giving me 13/07/2004
15:52. So it's ignoring the days.... Is it something to do with
formatting or is my formula the wrong one for what I am trying to
achieve???
Click to expand...

From HELP for TIME:

The decimal number returned by TIME is a value ranging from 0 (zero) to
0.99999999, representing the times from 0:00:00 (12:00:00 AM) to 23:59:59
(11:59:59 P.M.).

So yes, you are using the incorrect function.

The simplest is to use the formula =NOW() + Minutes/1440


--ron
 
Back
Top