Hi everyone,
Probably a really simple problem but I can't seem to figure it out from reading excel help files. I'm trying to create a worksheet which will calculate the running times of individual components (or episodes) on DVDs. The user will enter the end time of each component in Column A (formatted in minutes and seconds) and the worksheet will subtract the endtime just entered from the endtime in the sell above giving the running time of that component (in minutes and seconds).
Example:
The user enters the following values into column A: 23:41, 47:04, 01:11:16, 01:35:14.
The worksheet returns the following values in column B: 23:41, 23:23, 24:12, 23:58.
Also, it would be good to not have to enter colons/full stops between minutes and seconds in column A.
Example: entering 012506 and hitting enter will automatically convert to 01:25:06 in column A.
I'm using Excel 2007.
Thanks in advance for your help.
Bookmarks