Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to calculate days:Hours:Minutes:
Norman
this has helped me immensely, most of this thread was completely over my head, funny that what I needed was actually this straightforward procedure. Cheers "Norman Harker" wrote: Hi Kurewe! I think that your best bet may be to use Data Text to Columns on your data. You'll need to set up 6 empty columns to the right of your data. Then select your data Data Text to columns Delimited Use a space as the delimiter Add Other M as an additional delimiter Next Finish That gives you your numerics in columns A C and E Thereafter, it's easy to derive a formula to do what you want. Send a sample workbook if you like and I'll do it. On limited test data it appears to work OK. It certainly beats the complicated formulas although maybe a subroutine will be a better solution. -- Regards Norman Harker MVP (Excel) Sydney, Australia |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I calculate EDATE using days not months? | Excel Discussion (Misc queries) | |||
calculate difference in time to hours | Excel Worksheet Functions | |||
2003= negative number&2004= negative number How Do I Calculate gro | Excel Worksheet Functions | |||
Not able to calculate. | Excel Worksheet Functions | |||
How do you calculate the nth root of a number in Excel 2003? | Excel Worksheet Functions |