Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Dear All,
I have date field in Column A (e.g. 02/06/2005) and a time field in Column B (e.g. 05:15), how can I deduct 8 hours from this 2 fields (e.g. the results show 01/06/2005 21:15)?? Thanks a lot |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculate time difference to the half hour | Excel Worksheet Functions | |||
Calculate time | Excel Discussion (Misc queries) | |||
How to calculate time between two dates? | Setting up and Configuration of Excel | |||
calculate difference in time to hours | Excel Worksheet Functions | |||
calculate negative or positve difference in time | Excel Discussion (Misc queries) |