Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date/time calculation needed
I'm looking for a simple formula to add 140 hours from a entered data/time.
Example: In D6 a date/time is entered. In E6 140 hours is added giving the results in a new date/time format. This is probably simple but having problems making it work. Also, how would these cells be formatted? Thxs in advance |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date/time calculation needed
=d6+5+TIME(20,0,0)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Charlie7805" wrote in message ... I'm looking for a simple formula to add 140 hours from a entered data/time. Example: In D6 a date/time is entered. In E6 140 hours is added giving the results in a new date/time format. This is probably simple but having problems making it work. Also, how would these cells be formatted? Thxs in advance |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
date/time calculation needed
Enter your date/time in D6 and format as required (in the UK it would
be dd/mm/yy hh:mm:ss). Enter this formula in E6: =D6 + 140/24 and format E6 the same as D6 (you might want to miss the seconds off, though) Hope this helps. Pete Charlie7805 wrote: I'm looking for a simple formula to add 140 hours from a entered data/time. Example: In D6 a date/time is entered. In E6 140 hours is added giving the results in a new date/time format. This is probably simple but having problems making it work. Also, how would these cells be formatted? Thxs in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Financial Calculation Help Needed -- Annunity | Excel Worksheet Functions | |||
date/time stamp | Excel Worksheet Functions | |||
Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
Time Sheet Calculation Help Needed! | Excel Worksheet Functions | |||
How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions |