Date/Time Formula for Entry level XL user

talon1driver · #1 09-17-2014, 08:39 PM

Help.
I have searched the net and have come up thoroughly confused.

I am entering a date and time (military time) in one cell and need a formula that will subtract 60 Hours from that and give me a new date in a new cell.

Can anyone help. Thanks

macropod · #2 09-18-2014, 02:58 AM

Simply input the date & time in the reference cell (say, A1), then use a formula like:
=A1-60/24
in the destination cell.

FWIW, days are integer values. Each hour, therefore, is 1/24 of a day. 1 second is 1/86400 of a day!

talon1driver · #3 09-18-2014, 02:32 PM

Quote:

Originally Posted by macropod

Simply input the date & time in the reference cell (say, A1), then use a formula like:
=A1-60/24
in the destination cell.

FWIW, days are integer values. Each hour, therefore, is 1/24 of a day. 1 second is 1/86400 of a day!

Thanks Paul. Worked like a champ! Thread can be closed.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula In Excel To Prompt User To Input Date	pclutts	Excel Programming	4	08-31-2014 12:45 PM
MS Project to detect task level changes and record a date modified in custom field	RJTMEYER	Project	3	08-22-2014 07:38 AM
Formula to calculate Date and Time	funkyfido	Excel	2	06-25-2013 04:25 PM
User Form to Automate Entry in report	Panzer	Word VBA	2	08-22-2012 04:17 AM
Custom field formula not working at summary task level	abw1987	Project	3	10-05-2011 07:17 AM