#1
|
|||
|
|||
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
|
||||
|
||||
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
|
|||
|
|||
Thanks Paul. Worked like a champ! Thread can be closed.
|
Thread Tools | |
Display Modes | |
|
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 |