hechesspee
New Member
- Joined
- Aug 16, 2020
- Messages
- 10
- Office Version
- 365
- Platform
- Windows
Hi,
I'm looking to convert the below data with decimals in to seconds.
Column-->Data-->Desired format
A1-->0.3 --> 30
A2-->0.03 --> 03
A3-->1.3 --> 90
A4-->40.3 --> 2430
I used formula =A1/864 and used format [ss] and it gave me the correct result when the value is less than 1 i.e up to 0.59
When it is above 1 for example 1.3, it is converting into 130, not 90.
Can someone please advise me on how to get the right value?
Thanks
HSP
I'm looking to convert the below data with decimals in to seconds.
Column-->Data-->Desired format
A1-->0.3 --> 30
A2-->0.03 --> 03
A3-->1.3 --> 90
A4-->40.3 --> 2430
I used formula =A1/864 and used format [ss] and it gave me the correct result when the value is less than 1 i.e up to 0.59
When it is above 1 for example 1.3, it is converting into 130, not 90.
Can someone please advise me on how to get the right value?
Thanks
HSP