| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
need a formula to fix time
Bernard,
You're awsome, this is exactly what I needed. Thank you kind sir. "Bernard Liengme" wrote: Put this in B1 =IF(LEFT(A1)=":",TIME(0,MID(A1,2,2),MID(A1,5,2)),A 1) best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Rpt_Me4NotBeingSmart" wrote in message ... Lets say I have time in cell A1 that displays as :59:02. How can I write an If formula to say If A1 contains :xx:xx, then insert a zero at the beginning, otherwise do nothing? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time formula returns night time by mistake | Excel Discussion (Misc queries) | |||
| Time formula (difference of predicted and actual time) | Excel Discussion (Misc queries) | |||
| Calculating Time with Date/Time checking in formula | Excel Worksheet Functions | |||
| Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
| template or formula for start time -finish time -total hours ple | New Users to Excel | |||
Hybrid Mode
