Jan 12 2023 12:06 AM
I'm working in visual time management, so I have to count frames also.
That's why you are seeing an extra field which is a frame.(24f/1s)
When I'm working with 24 hours time format in excel, It's becoming 25:00:00:00 instead of 00:00:00:00.
How can I solve this.?
Jan 12 2023 09:41 PM
How to convert time format from 12 hour to 24 hour and vice versa in Excel?
When you work on Excel in your daily work, you may use different time format under different conditions, such as 12 hour format and 24 hour format as following screenshot shown. But, how could you convert time format from 12 hour to 24 hour and vice versa in Excel?
formula: TEXT(A2,"[hh]:mm:ss")
Hope I was able to help you with this link/info.
I know I don't know anything (Socrates)