Need to covert time to a decimal of minutes

[xrayservice]

Example 0:20 = 20 minutes

I can't use the time format, when changed to a number format its 0.1?

I would like 0:20 in time coverted over to just 20, and if 01:20 converted to 100 (for 100 minutes)

thanks

 

[Desu Nota from Columbus]

is the 0:20 currently a text format?

and wouldn't 1:20 be an hour and 20 minutes = 80 minutes?

 

[xrayservice]

No its in the time format

 

[xrayservice]

Ahhh yeah I feel dumb 01:20 would equal 60 + 20 = 80

 

[Desu Nota from Columbus]

which format for time? 13:30?

 

[xrayservice]

Still can't covert it over to a demical

 

[xrayservice]

Correct 13:30 using 24 hour clock

 

[Desu Nota from Columbus]

multiply it by 24*60 and convert to decimal


assuming it is in A1,

(=A1*24*60) --format=decimal

If you want to keep it in its current column, place 1440 in a blank cell copy/paste special -->multiply over the time.

 

[xrayservice]

It summed to 20.57 not the expected 20

 

[Desu Nota from Columbus]

hmmmmm, try playing around with the decimal length.


Your 0:20 might have hidden seconds which accounts for the .57

Try changing the time format to custom--> [h]:mm:ss and see if there are seconds attached