Re: Another Time Calulation Question - Sorry.

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks Ron, The minutes are calculating a treat (J4) :) The hours though
(I4) is returning all zero's.

But thanks for what I got so far.
--
I don't mind being wrong, I'd just like you to prove it! :)


"Ron Coderre" wrote:

If you really need to use that structure for recording time...
try this:

I4: =INT((TIME(G4,H4,0)-TIME(E4,F4,0)+TIME(C4,D4,0)-TIME(A4,B4,0))*24)
J4: =MOD((TIME(G4,H4,0)-TIME(E4,F4,0)+TIME(C4,D4,0)-TIME(A4,B4,0))*24,1)*60

copy those formulas down as far as you need.

Is that something you can work with?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"Dugster" <Dugster@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DD3D197F-76AA-4E78-969C-E9C2C3D94674@xxxxxxxxxxxxxxxx
Hi, I hope you don't mind a newbie asking newbie questions? :) I'm a
filling
short of a sandwich when it comes to excel, so please keep that in mind if
you decide to be so kind as to respond. Thanks!

I am trying to get the total hours and minutes worked over two periods to
show in columns I and J. Honest, I've used the help file and looked about
here but I just don't get it. :s I'd appreciate all and any help.
Thanks.

A B C D E F G H I J
1 AM AM PM PM Deficit B/F
2 Start Finish Start Finish
3 Hrs Mins Hrs | Mins
4 09 | 10 12 | 30 13 | 00 17 | 00
5 08 | 30 12 | 30 13 | 00 17 | 30
6 09 | 00 12 | 00 12 | 40 17 | 00



--
I don't mind being wrong, I'd just like you to prove it! :)



.

Relevant Pages

  • Re: Creating a UDF to convert ADDRESS function output as a reference
    ... (Or simply eliminated the statement altogether, ... Ron wrote: ... don't mind the fact that there will be no automatic ... please specify the Excel and VBA versions. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Another Time Calulation Question - Sorry.
    ... If you really need to use that structure for recording time... ... Microsoft MVP (Excel) ... show in columns I and J. Honest, I've used the help file and looked about ... I don't mind being wrong, I'd just like you to prove it! ...
    (microsoft.public.excel.newusers)
  • Re: Import Access Table into Excel. I appreciate your assistance. Thanks!
    ... Send me your database private ... Which Excel version do you use? ... Ron, on my access table the name of my categories are two letter words ... tried merging this as well to fit yours, but still no luck. ...
    (microsoft.public.excel.misc)
  • Re: Web Import
    ... Microsoft MVP Excel ... Thanks so much Ron!! ... >>> Sub Import ... >> ' Loop until the page is fully loaded ...
    (microsoft.public.excel.programming)
  • Re: Max function
    ... I DO have that "hardware problem" I mentioned to Dave? ... Ron ... Microsoft MVP (Excel) ... I'm using Excel 2003 SP2. ...
    (microsoft.public.excel)