ARGH! Time format is off BAD and more...
Hello again everyone!
This basic user has hit a road block. Can somebody see my error(s)?
Please see the "Statistics" sheet. Trying to find the answer to how much we are making per hour. Tried by converting the total hours to decimal and maybe that is where I went wrong...
Can someone help? I have spent weeks on this. What have I missed?
177:37:00*24 =177.6166667 hrs
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Hi
you have data in columns e and d that looks like times but in fact are not.
if you replace your data with true times then in column L the formula
is all that you need.
Please Login or Register to view this content.
The format for Time is under custom and looks like "hh:mm:ss" just delete the ":ss" and click ok.
Your original data will be displayed as "00:00" because Excel thinks that any number over zero is a date.
For hours you need to divide by 24 so 11 am = 11/24 an d11 pm =s 23/24
For minutes you need to divide by 1440 so 53 minutes = 53/1440
thats neither her nor there! op knows that hence the formula in col p that works
(but =TEXT(F3,"00\:00")-TEXT(E3,"00\:00") would work and is shorter)
op wants decimal time for 177:37:00 which is simply
177:37:00*24
then that would give an average per hour of $4,488.00/177.6166667
which =25.26789903
Awesome. Thank you all for your input. This makes sense now. Sometimes Excel formulas get me twisted-up.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks