| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
number to time
Help
I have 2 columns both with 4 digits as a time 1341 1415 . thease fields are brought in from another system and can not be changed to a time format what i am trying to do is work out the difference if it takes away 1341 from 1415 as a time rather than a number, so i get 34 as the result instead of 74 as i get at present. Thank you in advance for help Stan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| time into a number | Excel Discussion (Misc queries) | |||
| Every time i put a number with period it becomes a date and time | Excel Discussion (Misc queries) | |||
| Formula Help - Number to Time | Setting up and Configuration of Excel | |||
| Time as number | Excel Discussion (Misc queries) | |||
| Time to number | Excel Worksheet Functions | |||
Threaded Mode
