24 hours time formatting with frame

Copper Contributor
How do make 00:00:00:00 after in 24 hours time format.?

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.?

1 Reply

@salauddingreen 

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.

 

NikolinoDE

I know I don't know anything (Socrates)