<div>
Try:<br />
<br />
=A1-72/24<br />
<br />
formatted as Date/Time (you can make 72 variable)
</div>


<div>
This case, I can minus only minutes ! so no consistency. With your suggestion I cant subtract minutes !
</div>


<div>
Then<br />
<br />
=A1-(72+45/60)/24<br />
<br />
where 72 hours and 45 minutes
</div>


<div>
Let us take this example.<br />
<br />
My cell format is dd/mm/yyyy hh:mm AM/PM.<br />
Cell value is 30/03/2013 04:00 AM<br />
I need output 28/03/2013 10:00 AM.<br />
<br />
So how to get it ?
</div>


<div>
<div class="content wysiwyg-content">
Hi, I need to subtract X hours from given datetime cell in Excel 2007.<br />
<br />
It works fine if i subtract till 24 hours. example: A1-TIME(24,0,0).<br />
<br />
If i have to subtract 72 hours from Cell having value as 14/03/2013 4:00 AM it does not work as it does not recognize 72 hours but only works if it is 24 hours. But this is very critical for me. So how to achieve this ?
</div>
</div>


Hi, I need to subtract X hours from given datetime cell in Excel 2007.

It works fine if i subtract till 24 hours. example: A1-TIME(24,0,0).

If i have to subtract 72 hours from Cell having value as 14/03/2013 4:00 AM it does not work as it does not recognize 72 hours but only works if it is 24 hours. But this is very critical for me. So how to achieve this ?

Try:

=A1-72/24

formatted as Date/Time (you can make 72 variable)

This case, I can minus only minutes ! so no consistency. With your suggestion I cant subtract minutes !

Then

=A1-(72+45/60)/24

where 72 hours and 45 minutes

Let us take this example.

My cell format is dd/mm/yyyy hh:mm AM/PM.
Cell value is 30/03/2013 04:00 AM
I need output 28/03/2013 10:00 AM.

So how to get it ?

Subtract X hours from given datetime

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.