Converting time to a decimal

[richardthelionheart]

12:01

12:16

12:31

12:46

13:01

13:16

13:31

13:46

14:01

14:16

14:31

14:49

<colgroup><col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>

I've got 2 sets of data. One comes to me in usual time format (above) and one comes to me as a decimal. eg

18.22
18.32
12.04
12.58

Is it possible to somehow convert the time format to a decimal format so that I can sort them using row sort ?

Any help greatly appreciated.

 

[arthurbr]

Supposing your time is hours and minutes,enter 24 in an empty cell and copy it
Select your range with duration - Right click - Paste special - Multiply - OK - Format as required
If the time is minutes and seconds same thing but using 1440 instead of 24

 

[richardthelionheart]

Not sure if i was clear. I want 13:14 to be 13.14 That is actually 14 mins past 1 pm

 

[arthurbr]

Changing the format form hh:mm to hh.mm does not make any difference when sorting, as Excel sorts the underlying values ( which are fractions of a day)

Is there any chance your time is text looking like time manually right aligned in the cell) rather than real time ?

 

[dave2018]

Can u use the TEXT function?

=TEXT(A1,"hh.mm")