Forum

Notifications
Clear all

Calculate seconds in Excel

2 Posts
2 Users
0 Reactions
60 Views
(@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)
Posts: 4762
Member Admin
 

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

Mynda

 
Posted : 02/05/2022 2:19 am
Share: