Formula help...

B

BB

I need help in devising a formula that will subtract 100 hours from a
specific date and time. For example, if I entered a date and time (1/20/04
@ 1140) I would like the formula to subtract the 100 hours and give me that
date and time (1/16/04 @ 0740). Is that possible?
 
B

Bob Phillips

see response in .worksheet.functions

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
B

Bob Phillips

see response in .worksheet.functions

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top