Date & time subtraction

[mrinal saha]

HI Folks,

I have date & time in once cell as below

6/28/2012 12:04 am

What i want is to subtract 4 hrs from time ie; (12:04 - 4) = 8:04 pm and date should also change to 6/27/2012.

so my result would in another cell should look like

6/27/2012 8:04 pm

Is there any excel formula?

Thanks,
Mrinal

 

[Jonmo1]

Try

=A1-"4:00:00"

Or

=A1-TIME(4,0,0)

Or

A1-(4/24)

 

[Rick Rothstein]

Give this formula a try...

=A1-TIME(4,,)

 

[T. Valko]

HI Folks,

I have date & time in once cell as below

6/28/2012 12:04 am

What i want is to subtract 4 hrs from time ie; (12:04 - 4) = 8:04 pm and date should also change to 6/27/2012.

so my result would in another cell should look like

6/27/2012 8:04 pm

Is there any excel formula?

Thanks,
Mrinal

Try this...

A2 = 6/28/2012 12:04 AM

This formula entered in B2:

=A2-TIME(4,0,0)

Format in the date/time style of your choice.