how do i convert this (3:18:55:00) to hours and minutes format using MS excel? Please help…?
1. Save your file as a different name (to have a backup). 2. Select the cells that you want to modify. 3. Go to "Format", then "Cells", then "Number", then either "Time" or "Custom". 4. Choose the format that best fits your values.
Once you do that, you’ll be able to add / subtract durations of different items – such as calculating video timecodes.
2 Responses
Leave a Comment
|
July 21st, 2010 at 10:55 am
=time(hours,minutes,seconds)
=time(21,15,10) give you 9:15PM
References :
July 21st, 2010 at 11:22 am
1. Save your file as a different name (to have a backup). 2. Select the cells that you want to modify. 3. Go to "Format", then "Cells", then "Number", then either "Time" or "Custom". 4. Choose the format that best fits your values.
Once you do that, you’ll be able to add / subtract durations of different items – such as calculating video timecodes.
References :