Hello,
I am doing lists of songs: title, composer, etc and duration.
I wonder if it possible with Excel 2007 to enter the duration in minutes and seconds (mm:ss),
without always having to type first 00: for hh:?
Hello,
I am doing lists of songs: title, composer, etc and duration.
I wonder if it possible with Excel 2007 to enter the duration in minutes and seconds (mm:ss),
without always having to type first 00: for hh:?
xl wont know what ':34' is. (is it time, is it a budding list, a delimiter, etc)
but it does know time is: hh:nn
Thank you ranman256 for your answer.
I just wondered if there is a way to just write mm:ss instead of 00:mm:ss
Let Excel take the strain ...
see attached workbook
- easier to use different columns for minutes (col B) and seconds (col C)
- column D is formatted as TIME
Convert to time with formula in D2 copy down:
=1+(B2/((24*60))+(C2/(24*60*60)))
And to spot silly errors - in E2 copy down:
=IF(C2<60,"","How many seconds?")
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Thank you kev_, this is a cool formula
You are welcome. Thanks for reps
Final task
- see Thread Tools at top of thread - please mark thread as SOLVED if you now have your solution
thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks