| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
change time into simple number
I am using MS Office 2003. I am subtracting two times(hh:mm) and getting a
time value which I want to convert to number. For example: If the final value is 08:00 then I want to change it to 8 or if the value if 07:30 then it should be changed to 7.5 I tried using Integer function but it gives 00:00 or ####### Any idea guys?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change text to military time | Excel Worksheet Functions | |||
| time sheet drop down lists | Excel Discussion (Misc queries) | |||
| number returns only two decimal places after I change from text | Excel Discussion (Misc queries) | |||
| Time Stamp without change | Excel Discussion (Misc queries) | |||
| Time Stamp-With Change | Excel Discussion (Misc queries) | |||
Threaded Mode
