| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Date and time calculations
Could any body advise the formula req to deduct 15Hrs from 10/12/2004 06:00
giving the result of 09/12/2004 15:00 many thanks -- Tony |
|
#2
|
|||
|
|||
|
Hi Tony
in A1 10/12/04 06:00 in B1 15:00 in C1 =A1-B1 Cheers JulieD "Tony" wrote in message ... Could any body advise the formula req to deduct 15Hrs from 10/12/2004 06:00 giving the result of 09/12/2004 15:00 many thanks -- Tony |
|
#3
|
|||
|
|||
|
or even
="10/12/2004 06:00"-"15:00" -- HTH RP (remove nothere from the email address if mailing direct) "JulieD" wrote in message ... Hi Tony in A1 10/12/04 06:00 in B1 15:00 in C1 =A1-B1 Cheers JulieD "Tony" wrote in message ... Could any body advise the formula req to deduct 15Hrs from 10/12/2004 06:00 giving the result of 09/12/2004 15:00 many thanks -- Tony |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help - Information with time and date | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Date and Time Macro | Excel Discussion (Misc queries) | |||
Linear Mode
