Add 24hrs to a cell

[suprsnipes]

Hi,

How can you add 24hrs to a cell that is formatted as dd/mm/yyyy hh:mm I'm sure it's easier than I make it out to be

Regards,
suprsnipes

 

[jeffreybrown]

Since the format is just a mask, the time and date for right now is

40638.82361

so just add 1

In Excel a day is equal to 1 therefore 24 hours is equal to 1

 

[suprsnipes]

Thank you

 

[jeffreybrown]

You're welcome