time sheet claculation

Thanks for piping in Biff.

As a fella said above. I'm lazy.
Across my spreadsheet. I have the typical In Out In Out Total.
Down the right side I have the total for the days.
I want it to total at the bottom of the last right collumn.

Being lazy I would only like to enter the various times from the numeric
keypad. The decimal being used as the colon.
I can get the formula =(A2-B2) + (D2-C2). This will give me the correct
results using 24 time. Across the sheet. But I'm at a lose for getting
the proper total.

TIA
Frantic3D

sum()?

"Frantic3d" wrote:

> Thanks for piping in Biff.
>
> As a fella said above. I'm lazy.
> Across my spreadsheet. I have the typical In Out In Out Total.
> Down the right side I have the total for the days.
> I want it to total at the bottom of the last right collumn.
>
> Being lazy I would only like to enter the various times from the numeric
> keypad. The decimal being used as the colon.
> I can get the formula =(A2-B2) + (D2-C2). This will give me the correct
> results using 24 time. Across the sheet. But I'm at a lose for getting
> the proper total.
>
> TIA
> Frantic3D
>

This will give decimal hours

=(TIME(INT(B2),MOD(B2,1)*100,0)-TIME(INT(A2),MOD(A2,1)*100,0)+TIME(INT(D2),M
OD(D2,1)*100,0)-TIME(INT(C2),MOD(C2,1)*100,0))*24

--
HTH

Bob Phillips

"Barb R." <[email protected]> wrote in message
news:[email protected]...
> sum()?
>
> "Frantic3d" wrote:
>
> > Thanks for piping in Biff.
> >
> > As a fella said above. I'm lazy.
> > Across my spreadsheet. I have the typical In Out In Out Total.
> > Down the right side I have the total for the days.
> > I want it to total at the bottom of the last right collumn.
> >
> > Being lazy I would only like to enter the various times from the numeric
> > keypad. The decimal being used as the colon.
> > I can get the formula =(A2-B2) + (D2-C2). This will give me the correct
> > results using 24 time. Across the sheet. But I'm at a lose for getting
> > the proper total.
> >
> > TIA
> > Frantic3D
> >

"Bob Phillips" <[email protected]> wrote in
news:[email protected]:

> This will give decimal hours
>
> =(TIME(INT(B2),MOD(B2,1)*100,0)-TIME(INT(A2),MOD(A2,1)*100,0)+TIME(INT(
> D2),M OD(D2,1)*100,0)-TIME(INT(C2),MOD(C2,1)*100,0))*24
>

Will the formula allow me to input in decimal form>

You can input in A2:D2 in decimal form, like 10.3 is 10:30, 10.45 is 10:45,
etc, but it will return decimal hours, so a total of 8 hours 30 mins will
return as 8.5. This is easier for calculations, such as pay.

--
HTH

Bob Phillips

"Frantic3d" <[email protected]> wrote in message
news:[email protected]...
> "Bob Phillips" <[email protected]> wrote in
> news:[email protected]:
>
> > This will give decimal hours
> >
> > =(TIME(INT(B2),MOD(B2,1)*100,0)-TIME(INT(A2),MOD(A2,1)*100,0)+TIME(INT(
> > D2),M OD(D2,1)*100,0)-TIME(INT(C2),MOD(C2,1)*100,0))*24
> >
>
> Will the formula allow me to input in decimal form>