Never mind... I got it figured out

[Guest]

I'm working on a simple time calculating spreadsheet for a farmer.
A1 - Starting Time (formatted hh:mm AM/PM) <span style="color: #009900">7:00 AM</span>
A2 - Unpaid Break/Lunch (formatted as decimal) <span style="color: #009900">1.0</span>
A3 - Ending Time (formatted hh:mm AM/PM) <span style="color: #009900">5:00 PM</span>
A4 - Time worked (formatted as decimal) <span style="color: #009900">9.0</span>


What is the formula for A4 to properly calculate time worked and display it as decimal value?

 

[Guest]

Re: I suck at Excel - Are you better?

Never mind. I got it.

A4 =(A3/0.041666667)-(A1/0.041666667)-A2

 

[Queequeg]

Re: I suck at Excel - Are you better?

So you were just posting out load?

 

[Guest]

Re: I suck at Excel - Are you better?

<div class="ubbcode-block"><div class="ubbcode-header">Originally Posted By: queequeg</div><div class="ubbcode-body">So you were just posting out load? </div></div>

Huh?

 

[Lindy]

Re: I suck at Excel - Are you better?

I suspect that he meant to type, "So you were just posting out loud?", as in "thinking out loud."

 

[ARP]

Re: I suck at Excel - Are you better?

Glad to have been of such great help to you. The next time you run into some issue with Excel then feel free to PM me and I will help you again

Seriously, I am pretty good at Excel so if you really do have a problem then I can fix it

 

[Queequeg]

Re: I suck at Excel - Are you better?

<div class="ubbcode-block"><div class="ubbcode-header">Originally Posted By: tucker301</div><div class="ubbcode-body"><div class="ubbcode-block"><div class="ubbcode-header">Originally Posted By: queequeg</div><div class="ubbcode-body">So you were just posting out load? </div></div>

Huh?

</div></div>

Meant to say "Loud"...

Kills the modest humor of the quip

 

[Guest]

Re: I suck at Excel - Are you better?

<div class="ubbcode-block"><div class="ubbcode-header">Originally Posted By: Lindy</div><div class="ubbcode-body">I suspect that he meant to type, "So you were just posting out loud?", as in "thinking out loud."
</div></div>

I know, but I just couldn't let it slide. Not with him.

It is a "him", isn't it?

 

[Queequeg]

Re: I suck at Excel - Are you better?

<div class="ubbcode-block"><div class="ubbcode-header">Quote:</div><div class="ubbcode-body">It is a "him", isn't it? </div></div>

Like in your nightmares!