| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Getting Date difference....help (difficult)
i have this column B named Update Time 2005080112:22:35 2005080112:46:20 2005080200:30:21 and i have column F named New Shift end 20050801 20:30 20050801 19:30 20050803 18:00 well i need to find the date difference between this 2 time.....Column F minus Column B.. i need to get this difference in column H.... for eg.. 20050801 20:30 - 2005080112:22:35 will give me 7:57:55.. for eg... 20050803 18:00 - 2005080200:30:21 will give me 41:29:39 (its a day more so need to plus 24 hours) both column B and F are in string format.....any help will be greatly appreciated! ;) -- forevercalz ------------------------------------------------------------------------ forevercalz's Profile: http://www.excelforum.com/member.php...o&userid=28931 View this thread: http://www.excelforum.com/showthread...hreadid=490649 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Difference betwen Excel Date () Function and System Date | Excel Worksheet Functions | |||
| Difference System date and Excel Date function | Excel Worksheet Functions | |||
| Date Difference | Excel Discussion (Misc queries) | |||
| Difference between last date of month and given date | Excel Worksheet Functions | |||
| Calculating Difference Between Start Date & Time And End Date & Ti | Excel Discussion (Misc queries) | |||
![forevercalz[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
