microsoft works or excel time formula
Tubs
this is what I need,
If I leave the house on 6/25/03 at 14:00 and travel 56 hours is there a
formula that would tell me the day and time of arrival? I really need this
and would appreciate any and all help.
Thanks
Tubs
Paul Corrado
Cell A2 =52/24
Cell A3 =A1+A2
Excel recognizes hours as parts of days and each day has a value of 1
HTH
PC
"Tubs" <that's a secret> wrote in message
news:vfrub77...@corp.supernews.com...
Norman Harker
Alternative to Paul's approach could be:
A1
25-Jun-2003 14:00
[Or entered in your short date format mm/dd/yy]
A2
56:00
[Don't worry about the mysterious 1900 date in the formula bar]
A3
=A1+A2
In your format this returns: 6/27/03 22:00
But as Paul explained. Excel records dates as serial numbers with time
being a decimal part of a day. That peculiar formula bar
interpretation of 56:00 is because the base is Midnight at the
beginning of 1-Jan-1900
Personally, I avoid those date formats of yours like the plague. The
date 10/11/12 can mean:
10-Nov-1912
10-Nov-2012
11-Oct-1912
11-Oct-2012
12-Nov-1910
12-Nov-2012
It all depends upon the Regional Options Settings and they can vary.
Of course interpretation of the result will vary according to custom
of the user. But my 25-Jun-2003 is interpreted unequivocally by all
English language versions of Excel. To be pedantic, I could use
2003-06-27 as my date entry and get all English and Foreign languages
to understand what I'm about.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Public Holidays Saturday: Bosnia-Herzegovina (Vivovdan (Orthodox));
Chile (St. Peter & St. Paul Day); Haiti (M'Guine Sauveur table servie
pour maitresse Erzulie, Tenaisse, Mambo); Taiwan (Birthday of Kuan
Kung (God of War)); USA (WW1 Day).
njha...@optusnet.com.au
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"Tubs" <that's a secret> wrote in message
news:vfrub77...@corp.supernews.com...