| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert number to time
Hi all, I cannot figure out how to convert a number to time format (eg: 1340 to 13:40). I've tried following the directions 'here' (http://www.exceltip.com/st/Convertin...Value/99.html), but there seems to be an error in the IF statement (no logic check?). I can't seem to fix it. Any help would be greatly appreciated. Thanks in advance, Nick -- NCSemon ------------------------------------------------------------------------ NCSemon's Profile: http://www.excelforum.com/member.php...o&userid=35999 View this thread: http://www.excelforum.com/showthread...hreadid=557869 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling Data off Web - Need Function Help | Excel Worksheet Functions | |||
| how do I convert a general number to a time format? | Excel Worksheet Functions | |||
| Convert a number to a time | Excel Discussion (Misc queries) | |||
| convert number to time format? | Excel Discussion (Misc queries) | |||
| how do i convert a number into minutes for a time of completion c. | Excel Discussion (Misc queries) | |||
Threaded Mode
