Search results for query: *

I've searched here, there everywhere and tried 50 different ways to do this with absolutely no luck!!!!!!!!!!!!!! I have a monthly file with a worksheet for each day and at the end there is a summary worksheet-with formulas cumulating the values for the month. When I try to copy that worksheet...

I have a MAX formula calculating the difference in time frames and selecting the greater of the two. i.e. =MAX(I23-E23,I23-D23) I23 is 02:52 (End of service time) E23 is 02:12 (ATA) D23 is 22:15 (ETA-from the night before) the answer in K23 is 40 but it should be 277 my problem is that the...

Yes-I got 40.48......and then I changed field to General and got exactly as I needed..............YES!!!!!!!!!!!!!! Another obstacle overcome with the help of great people on TEK-TIPS... MANY THANKS!!!!!!!!!!

The reason 90 minutes has to be listed as 1.5 hours(1hour30min) instead of 1 hour.30 min is because that time frame is being applied to a dollar amount later.i.e. Person makes $50 hr. we are billing service time of 1.5*$50=$75 owed. *Anotherhiggins* you helped me on my other issue-calculating...

D1-custom[mm] - has the sum total of minutes from A1:C1 all custom[mm](I am calculating minutes gone by) so we'll say that number is 200 E1-formula =D1-custom[h].mm which shows as 3.2 I need it to show 3.33 (as per a 100 minute clock)-this is used for billing purposes I've tried =D1/60...

Brilliant-huge help, massive time and headache saver!!!!!!!!!!!!!!!!!!!!!!!!!!! Thanks a bunch!!!!!!!!!!!!!!!!!

Thanks for the info-I've combined what you wrote with what I had it looks like =MAX((HOUR(I5-E5)*60+MINUTE(I5-E5)),(HOUR(I5-D5)*60+MINUTE(I5-D5))) This formula works great except in cases where End time happens to be earlier than than the ETA. Example (I5 is 09:50 and D5 is 10:00) Excel gives a...

Thanks for the info-I've combined what you wrote with what I had it looks like =MAX((HOUR(I5-E5)*60+MINUTE(I5-E5)),(HOUR(I5-D5)*60+MINUTE(I5-D5))) This formula works great except in cases where End time happens to be earlier than than the ETA. Example (I5 is 10:00 and D5 is 09:50) Excel gives a...

HERE GOES...column at top ETA(A1) ATA(B1) END(C1) TIME(D1) 10:15 10:30 10:46 16 =HOUR(C1-B1)*60+MINUTE(C1-B1) So normally I need the C1-B1 for stats...but IF C1-A1 is greater then I need that number-PLEASE HELP. The formula I have in D1 is to convert the time...

What I have in my report Division Type # of Type Div.Tot. Share% A Good 1 1 Good 1 1 Good 1 1 Bad 1...