Timecard: convert time h:mm to number (example 8.75 hrs) to add totals

[vicki_2003]

I want to take a cell that says =min(c4-b4-h4,8/24)

This cell actually shows my regular hours as 8:75.

I want to convert the figure 8:75 to a number 8.75.

This will allow me to add the numbers across the board.

Can anyone help me to do this?

 

[J.E. McGimpsey]

Does it *really* show 8:75? In that case you've got something
seriously weird going on.... I suspect it's actually 8:45.

In any case, XL stores times as fractional days (e.g., 3:00 =
0.125), so you just need to multiply by 24. For instance, you could
instead use:

=MIN((C4-B4-H4)*24,8)

But note that that formula will *never* return 8.75, since you're
asking for the MINimum. I'd guess you want:

=MAX((C4-B4-H4)*24, 8)