A simple question!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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-
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Match function with time 3
count days hours and minutes 13
Problem with V-Basic code for displaying times in hh:mm format 1
Getting MM-DD HH:MM out of Julian date 4
Get time from a Date & Time field 15
VB routine to change display for time not working 5
Calculating Time difference 6
Counting dates & time. 2

Back
Top