Microsoft Office Forums Date/Time Formula for Entry level XL user
 Register FAQ Search Today's Posts Mark Forums Read

#1
09-17-2014, 08:39 PM
 talon1driver Mac OS X Office for Mac 2011 Novice Join Date: Sep 2014 Posts: 2
Date/Time Formula for Entry level XL user

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
#2
09-18-2014, 02:58 AM
 macropod Windows 7 64bit Office 2010 32bit Administrator Join Date: Dec 2010 Location: Canberra, Australia Posts: 21,252

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!
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
#3
09-18-2014, 02:32 PM
 talon1driver Mac OS X Office for Mac 2011 Novice Join Date: Sep 2014 Posts: 2

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.

 Thread Tools Display Modes Linear Mode

 Similar Threads Thread Thread Starter Forum Replies Last Post pclutts Excel Programming 4 08-31-2014 12:45 PM RJTMEYER Project 3 08-22-2014 07:38 AM funkyfido Excel 2 06-25-2013 04:25 PM Panzer Word VBA 2 08-22-2012 04:17 AM abw1987 Project 3 10-05-2011 07:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:10 PM.

 -- Default Style -- Lightweight -- New Mobile Contact Us - Privacy Statement - Top