Search results

Woodduck you are awesome, thank you

I will try that, thank you so much

Hi everyone, my name is Deb, and of course I am in need of expert help again, you've been great in the past and I know I can depend on you this time as well. This is prolly a simple formula but I can't seem to figure out what I need to do. I have a dollar value that I need multiplied by the...

thank you P0lar

got it, finally worked, thanks everyone. now how do I change it from 14:42 to a decimal?

if today is cell c23 and yesterday is cell d23 how do I do the formula, maybe that's why it's not working

Narayank991, I can't get Hui's formula to work, what am I doing wrong? when I do it it comes up with 4:48:00 PM

P0lar I tried that formula and it didn't work so what am I missing? DRIVERS HOURS OF SERVICE LOG TUESDAY DATE DRIVER IN-TODAY OUT-YESTERDAY REST TIME-HRS 6/4/13 BW 5:08 14:26 6/4/13 MH 6:25 16:39 6/4/13 TA 6:25 17:32 6/4/13 KJ...

sorry if I didn't explain well enough. I have to report the driver's rest time they are required to rest at least 10 hours before driving again so I'm trying to find a formula that can calculate the hours they rested in between shifts without having to do it myself (yes I'm lazy, but also like...

actually P0lar it needs to be in hours not in time for the result so how would that work?

Hi Hui, i don't really understand what you are saying for =today()+in time-(today()-1+out time. the out time is yesterdays out time and the in time is today, could you please elaborate on this for me?

Good morning, my name is Deb and I have an excel formula that I need but can't seem to figure out how to do it. If a driver comes in at 5:00am today and yesterday left work at 17:00pm how many hours went by until they came in today. It should equal 12 hours but I can't seem to get it to...

it worked thank you so much

great thank you so much I'll try that. thank you again.

Hi my name is Deb, been on the site before and can't express how helpful it's been, you are wonderful people. So my new dilemma is this: column c trucker's name column g internal cost column h external cost if it's an internal cost it's only in the internal cost column g, if it's...

it worked thank you so much now I have my options.

ok thank you so much

",/;" where would it go? after what function?

You are THE BEST, the other one worked, thank you, thank you, thank you, you are the goddess of EXCEL.

ok so Brian is in column c2:c202 and logs,shuttle,pulp are in d2:d202 and the sum that I need are in f2:f202 looks correct but not working

=SUMPRODUCT((C2:C202="brian")*ISNUMBER(FIND(D2:D202,{"logs","shuttle","pulp"},1))*F2:F202) I'm sorry but it didn't work, not sure if it's because of the 1 or not. I dont know what you mean by Request to Mods. Some posts got stuck in "spam" filter, please delete 'em??? is this something I...

Can you tell me what the 1 stands for?

I will try this and let you know, I thank you for your assistance.

I'm kind of new working with various formulas, like sumif, etc I am hopeful this is an easy question for someone. I have 4 columns with information, example: truck# driver# loadinfo hours 190 brian logs 5 190 brian shuttle 4 190 brian pulp 2 190 brian...