Calculate seconds in Excel

General Excel Questions & Answers

2 Posts

2 Users

0 Reactions

594 Views

RSS

lea cohen

(@usb)

Posts: 244

Honorable Member

Topic starter

The attachment should calculate the minutes and seconds
And that gives me a 00:00 result Why?

Posted : 01/05/2022 11:57 pm

Mynda Treacy

(@mynda)

Posts: 4783

Member Admin

Because the values in column A are text, not proper date/time serial numbers.

Mynda

Posted : 02/05/2022 2:19 am

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed