A simple question!!

D

Don

HI all,

Given a time period A formatted as hh:mm, how do you divide a 24 hr period
(formatted as hh:mm) by A? Would appreciate answers. I am getting dubious
answers!

Don-
 
P

Peo Sjoblom

Multiply with 24 first, one day is 1 in Excel and one hour is 1/24 so if you
have an hourly rate in B2 and the time worked in A2 use

=B2*A2*24

and format as currency
 
P

Pete_UK

Not sure that this is what the OP asked for - he might want to know
how many 20 minute periods there are in 17 hours (for example).

With the shorter time in A1 and the longer period in B1, the formula
would be:

=B1/A1

but make sure the cell containing the formula is formatted either as
General or as Number.

Hope this helps.

Pete
 
Top