Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-17-2014, 08:39 PM
talon1driver talon1driver is offline Date/Time Formula for Entry level XL user Mac OS X Date/Time Formula for Entry level XL user Office for Mac 2011
Novice
Date/Time Formula for Entry level XL user
 
Join Date: Sep 2014
Posts: 2
talon1driver is on a distinguished road
Default 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
Reply With Quote
  #2  
Old 09-18-2014, 02:58 AM
macropod's Avatar
macropod macropod is offline Date/Time Formula for Entry level XL user Windows 7 64bit Date/Time Formula for Entry level XL user Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,224
macropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant futuremacropod has a brilliant future
Default

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]
Reply With Quote
  #3  
Old 09-18-2014, 02:32 PM
talon1driver talon1driver is offline Date/Time Formula for Entry level XL user Mac OS X Date/Time Formula for Entry level XL user Office for Mac 2011
Novice
Date/Time Formula for Entry level XL user
 
Join Date: Sep 2014
Posts: 2
talon1driver is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date/Time Formula for Entry level XL user Formula In Excel To Prompt User To Input Date pclutts Excel Programming 4 08-31-2014 12:45 PM
Date/Time Formula for Entry level XL user 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
Date/Time Formula for Entry level XL user User Form to Automate Entry in report Panzer Word VBA 2 08-22-2012 04:17 AM
Date/Time Formula for Entry level XL user Custom field formula not working at summary task level abw1987 Project 3 10-05-2011 07:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:00 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft