Converting time to a decimal

[richardthelionheart]

<colgroup><col style="width:48pt" width="64"> </colgroup><tbody>
[TD="class: xl63, width: 64, align: right"]12:01[/TD]

[TD="class: xl63, align: right"]12:16[/TD]

[TD="class: xl63, align: right"]12:31[/TD]

[TD="class: xl63, align: right"]12:46[/TD]

[TD="class: xl63, align: right"]13:01[/TD]

[TD="class: xl63, align: right"]13:16[/TD]

[TD="class: xl63, align: right"]13:31[/TD]

[TD="class: xl63, align: right"]13:46[/TD]

[TD="class: xl63, align: right"]14:01[/TD]

[TD="class: xl63, align: right"]14:16[/TD]

[TD="class: xl63, align: right"]14:31[/TD]

[TD="class: xl63, align: right"]14:49[/TD]

</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")