Time calc involving two days

[oomfh]

I know how to create time calc formulas during the same date - but not when you cross (midnight) into a second date.

Any quick examples would be greatly appreciated . . . . .

I assume there's a formula that covers both scenarios?

 

[T. Valko]

Now I need to divide $0.00 by h:mm, i.e.,

$263.30/12:15 to get $21.49 . . . but I am gettting $5.16

In other words I need the 12 hrs 15 mins to be interpreted as 12.25

To convert a time value like 12:15 to a decimal value like 12.25, multiply the time value by 24:

A1 = 12:15
B1 = $263.30

So, you would do:

=B1/(A1*24)

Result = 21.4938775510204

And you'll probably want to round that to 2 decimal places:

=ROUND(B1/(A1*24),2)

Result = 21.49

Format as desired.

 

[oomfh]

You will need to multiply the 12:15 by 24.

12:15 is actually .510417 since Excel sees a 24 hour period as 1

Yes, this works much better than / or * 60

and yes I am building a library of examples.

Thx to all