I have a spreadsheet with several "time" columns. I then bring this data to
a pivot table. Before doing that, I have another column set up that converts
h:mm to a decimal format (i.e: 3:30 convert to 3.5).

I do this conversion with the following formula:
=(P5875-INT(P5875))*24

This works for most times, except for anything that is 24:00 or greater. In
this case, it subtracts 24 from the total (i.e., 24:00 converts to 0.00,
26:25 converts to 2.25).

Is there another formula I can use that will correctly convert ALL times?

Thank you