Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
TimeValue formula
Hello,
I have a TimeValue formula that works well for hh:mm, but I also need to expand this to hh:mm:ss, and I've tried several times to get this right, but can't seem to come up with the proper combination. Here's the one that works: =IF(F4="","",IF(F4<1000,TIMEVALUE(LEFT(F4,1)&":"&R IGHT(F4,2)),TIMEVALUE(LEFT(F4,2)&":"&RIGHT(F4,2))) ) With the above formula in F5, if I enter 1234 in cell F4, then in cell F5 I get 12:34. I need to be able to enter 123456 to get 12:34:56. Thanks. Frank |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reusing formula | Excel Discussion (Misc queries) | |||
2 Nesting questions | Excel Worksheet Functions | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |