time clock formulas

[Andrew]

I have created a formula for calculating total hours / day
the times are entered in military time
a1 = 7:30, b1 = 15:30, c1= =(b1-a1)*24, and it works great, however I can
not get those numbers in the C colum to add up for a rolling total

HELP !!!!!

[Gary''s Student]

Try formatting the sum as;

[h]:mm
--
Gary's Student


"Andrew" wrote:

> I have created a formula for calculating total hours / day
> the times are entered in military time
> a1 = 7:30, b1 = 15:30, c1= =(b1-a1)*24, and it works great, however I can
> not get those numbers in the C colum to add up for a rolling total
>
> HELP !!!!!

[Andrew]

I'm not sure what you mean, sorry...

"Gary''s Student" wrote:

> Try formatting the sum as;
>
> [h]:mm
> --
> Gary's Student
>
>
> "Andrew" wrote:
>
> > I have created a formula for calculating total hours / day
> > the times are entered in military time
> > a1 = 7:30, b1 = 15:30, c1= =(b1-a1)*24, and it works great, however I can
> > not get those numbers in the C colum to add up for a rolling total
> >
> > HELP !!!!!

[Bob Phillips]

As they are just decimal numbers now, they should simply add up. What is the
problem you get, give an example?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Andrew" <[email protected]> wrote in message
news:[email protected]...
> I'm not sure what you mean, sorry...
>
> "Gary''s Student" wrote:
>
> > Try formatting the sum as;
> >
> > [h]:mm
> > --
> > Gary's Student
> >
> >
> > "Andrew" wrote:
> >
> > > I have created a formula for calculating total hours / day
> > > the times are entered in military time
> > > a1 = 7:30, b1 = 15:30, c1= =(b1-a1)*24, and it works great, however I
can
> > > not get those numbers in the C colum to add up for a rolling total
> > >
> > > HELP !!!!!

[Peo Sjoblom]

Maybe Andrew meant something like this in C2 so the values accumulate

=(B2-A2)*24+C1

and copy down

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Bob Phillips" <[email protected]> wrote in message
news:[email protected]...
> As they are just decimal numbers now, they should simply add up. What is
> the
> problem you get, give an example?
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "Andrew" <[email protected]> wrote in message
> news:[email protected]...
>> I'm not sure what you mean, sorry...
>>
>> "Gary''s Student" wrote:
>>
>> > Try formatting the sum as;
>> >
>> > [h]:mm
>> > --
>> > Gary's Student
>> >
>> >
>> > "Andrew" wrote:
>> >
>> > > I have created a formula for calculating total hours / day
>> > > the times are entered in military time
>> > > a1 = 7:30, b1 = 15:30, c1= =(b1-a1)*24, and it works great, however I
> can
>> > > not get those numbers in the C colum to add up for a rolling total
>> > >
>> > > HELP !!!!!
>
>

[Andrew]

I need each row to have its own total, and then have a total at the bottem of
each column.

"Peo Sjoblom" wrote:

> Maybe Andrew meant something like this in C2 so the values accumulate
>
> =(B2-A2)*24+C1
>
> and copy down
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> Northwest Excel Solutions
>
> www.nwexcelsolutions.com
>
> (remove ^^ from email address)
>
> Portland, Oregon
>
>
>
>
> "Bob Phillips" <[email protected]> wrote in message
> news:[email protected]...
> > As they are just decimal numbers now, they should simply add up. What is
> > the
> > problem you get, give an example?
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from email address if mailing direct)
> >
> > "Andrew" <[email protected]> wrote in message
> > news:[email protected]...
> >> I'm not sure what you mean, sorry...
> >>
> >> "Gary''s Student" wrote:
> >>
> >> > Try formatting the sum as;
> >> >
> >> > [h]:mm
> >> > --
> >> > Gary's Student
> >> >
> >> >
> >> > "Andrew" wrote:
> >> >
> >> > > I have created a formula for calculating total hours / day
> >> > > the times are entered in military time
> >> > > a1 = 7:30, b1 = 15:30, c1= =(b1-a1)*24, and it works great, however I
> > can
> >> > > not get those numbers in the C colum to add up for a rolling total
> >> > >
> >> > > HELP !!!!!
> >
> >
>
>

[Peo Sjoblom]

Just use =SUM(C1:C?)

where C? is the last cell with data that you want to include

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Andrew" <[email protected]> wrote in message
news:[email protected]...
>I need each row to have its own total, and then have a total at the bottem
>of
> each column.
>
> "Peo Sjoblom" wrote:
>
>> Maybe Andrew meant something like this in C2 so the values accumulate
>>
>> =(B2-A2)*24+C1
>>
>> and copy down
>>
>> --
>>
>> Regards,
>>
>> Peo Sjoblom
>>
>> Northwest Excel Solutions
>>
>> www.nwexcelsolutions.com
>>
>> (remove ^^ from email address)
>>
>> Portland, Oregon
>>
>>
>>
>>
>> "Bob Phillips" <[email protected]> wrote in message
>> news:[email protected]...
>> > As they are just decimal numbers now, they should simply add up. What
>> > is
>> > the
>> > problem you get, give an example?
>> >
>> > --
>> > HTH
>> >
>> > Bob Phillips
>> >
>> > (remove nothere from email address if mailing direct)
>> >
>> > "Andrew" <[email protected]> wrote in message
>> > news:[email protected]...
>> >> I'm not sure what you mean, sorry...
>> >>
>> >> "Gary''s Student" wrote:
>> >>
>> >> > Try formatting the sum as;
>> >> >
>> >> > [h]:mm
>> >> > --
>> >> > Gary's Student
>> >> >
>> >> >
>> >> > "Andrew" wrote:
>> >> >
>> >> > > I have created a formula for calculating total hours / day
>> >> > > the times are entered in military time
>> >> > > a1 = 7:30, b1 = 15:30, c1= =(b1-a1)*24, and it works great,
>> >> > > however I
>> > can
>> >> > > not get those numbers in the C colum to add up for a rolling total
>> >> > >
>> >> > > HELP !!!!!
>> >
>> >
>>
>>

[Andrew]

I know that, but t does not work
a b c
1 7:30 17:30 10.00
2 7:30 17:30 10.00
3 7:30 10:30 3.00
4 7:15 17:30 10.25
5 7:15 17:30 10.25

#VALUE!


Formula for c3 is =(b1-a1)*24

hope ths helps

"Peo Sjoblom" wrote:

> Just use =SUM(C1:C?)
>
> where C? is the last cell with data that you want to include
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> Northwest Excel Solutions
>
> www.nwexcelsolutions.com
>
> (remove ^^ from email address)
>
> Portland, Oregon
>
>
>
>
> "Andrew" <[email protected]> wrote in message
> news:[email protected]...
> >I need each row to have its own total, and then have a total at the bottem
> >of
> > each column.
> >
> > "Peo Sjoblom" wrote:
> >
> >> Maybe Andrew meant something like this in C2 so the values accumulate
> >>
> >> =(B2-A2)*24+C1
> >>
> >> and copy down
> >>
> >> --
> >>
> >> Regards,
> >>
> >> Peo Sjoblom
> >>
> >> Northwest Excel Solutions
> >>
> >> www.nwexcelsolutions.com
> >>
> >> (remove ^^ from email address)
> >>
> >> Portland, Oregon
> >>
> >>
> >>
> >>
> >> "Bob Phillips" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > As they are just decimal numbers now, they should simply add up. What
> >> > is
> >> > the
> >> > problem you get, give an example?
> >> >
> >> > --
> >> > HTH
> >> >
> >> > Bob Phillips
> >> >
> >> > (remove nothere from email address if mailing direct)
> >> >
> >> > "Andrew" <[email protected]> wrote in message
> >> > news:[email protected]...
> >> >> I'm not sure what you mean, sorry...
> >> >>
> >> >> "Gary''s Student" wrote:
> >> >>
> >> >> > Try formatting the sum as;
> >> >> >
> >> >> > [h]:mm
> >> >> > --
> >> >> > Gary's Student
> >> >> >
> >> >> >
> >> >> > "Andrew" wrote:
> >> >> >
> >> >> > > I have created a formula for calculating total hours / day
> >> >> > > the times are entered in military time
> >> >> > > a1 = 7:30, b1 = 15:30, c1= =(b1-a1)*24, and it works great,
> >> >> > > however I
> >> > can
> >> >> > > not get those numbers in the C colum to add up for a rolling total
> >> >> > >
> >> >> > > HELP !!!!!
> >> >
> >> >
> >>
> >>
>
>

[Peo Sjoblom]

Are you saying that if you use

=SUM(C1:C5)

you'll get a value error?



--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Andrew" <[email protected]> wrote in message
news:[email protected]...
>I know that, but t does not work
> a b c
> 1 7:30 17:30 10.00
> 2 7:30 17:30 10.00
> 3 7:30 10:30 3.00
> 4 7:15 17:30 10.25
> 5 7:15 17:30 10.25
>
> #VALUE!
>
>
> Formula for c3 is =(b1-a1)*24
>
> hope ths helps
>
> "Peo Sjoblom" wrote:
>
>> Just use =SUM(C1:C?)
>>
>> where C? is the last cell with data that you want to include
>>
>> --
>>
>> Regards,
>>
>> Peo Sjoblom
>>
>> Northwest Excel Solutions
>>
>> www.nwexcelsolutions.com
>>
>> (remove ^^ from email address)
>>
>> Portland, Oregon
>>
>>
>>
>>
>> "Andrew" <[email protected]> wrote in message
>> news:[email protected]...
>> >I need each row to have its own total, and then have a total at the
>> >bottem
>> >of
>> > each column.
>> >
>> > "Peo Sjoblom" wrote:
>> >
>> >> Maybe Andrew meant something like this in C2 so the values accumulate
>> >>
>> >> =(B2-A2)*24+C1
>> >>
>> >> and copy down
>> >>
>> >> --
>> >>
>> >> Regards,
>> >>
>> >> Peo Sjoblom
>> >>
>> >> Northwest Excel Solutions
>> >>
>> >> www.nwexcelsolutions.com
>> >>
>> >> (remove ^^ from email address)
>> >>
>> >> Portland, Oregon
>> >>
>> >>
>> >>
>> >>
>> >> "Bob Phillips" <[email protected]> wrote in message
>> >> news:[email protected]...
>> >> > As they are just decimal numbers now, they should simply add up.
>> >> > What
>> >> > is
>> >> > the
>> >> > problem you get, give an example?
>> >> >
>> >> > --
>> >> > HTH
>> >> >
>> >> > Bob Phillips
>> >> >
>> >> > (remove nothere from email address if mailing direct)
>> >> >
>> >> > "Andrew" <[email protected]> wrote in message
>> >> > news:[email protected]...
>> >> >> I'm not sure what you mean, sorry...
>> >> >>
>> >> >> "Gary''s Student" wrote:
>> >> >>
>> >> >> > Try formatting the sum as;
>> >> >> >
>> >> >> > [h]:mm
>> >> >> > --
>> >> >> > Gary's Student
>> >> >> >
>> >> >> >
>> >> >> > "Andrew" wrote:
>> >> >> >
>> >> >> > > I have created a formula for calculating total hours / day
>> >> >> > > the times are entered in military time
>> >> >> > > a1 = 7:30, b1 = 15:30, c1= =(b1-a1)*24, and it works great,
>> >> >> > > however I
>> >> > can
>> >> >> > > not get those numbers in the C colum to add up for a rolling
>> >> >> > > total
>> >> >> > >
>> >> >> > > HELP !!!!!
>> >> >
>> >> >
>> >>
>> >>
>>
>>

[de vlam johan]

it is easy Andrew.pse find below copy of excel sheet example;copy it directly
into a sheet.
start time ending time working time
hours minutes
12:23 14:42 2,00 19 2:19
14:41 14:42 0,00 1 0:01
12:12 14:42 2,00 30 2:30
11:23 14:42 3,00 19 3:19

totals: 7,00 69,00 8 uur en 9 minuten solution a)
8:09 solution b)
8:09 solution c)

formula's were written in dutch as you can see below (relevant cellcontents
preceeded by an apostrophy)

12:23:00 14:42:00 =UUR(B14-A14) =MINUUT(B14-A14) =TIJD(UUR(B14-A14);MINUUT(B14-A14);SECONDE(I14-J14))
14:41:00 14:42:00 =UUR(B15-A15) =MINUUT(B15-A15) =TIJD(UUR(B15-A15);MINUUT(B15-A15);SECONDE(I15-J15))
12:12 14:42 2,00 30 2:30
11:23 14:42 3,00 19 3:19

totaal: =SOM(D14:D17) =SOM(E14:E17) =TEKST.SAMENVOEGEN((D19+INTEGER(E19/60))&" uur en ";REST(E19;60)&" minuten")
=TIJD(D19;E19;F19)
=SOM(G14:G17)
Believe required English formula version as follows:

hour minute concatenate integer rest(or remainder??)
sum sum time
second


"Andrew" wrote:

> I have created a formula for calculating total hours / day
> the times are entered in military time
> a1 = 7:30, b1 = 15:30, c1= =(b1-a1)*24, and it works great, however I can
> not get those numbers in the C colum to add up for a rolling total
>
> HELP !!!!!

[Andrew]

That's correct

"Peo Sjoblom" wrote:

> Are you saying that if you use
>
> =SUM(C1:C5)
>
> you'll get a value error?
>
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> Northwest Excel Solutions
>
> www.nwexcelsolutions.com
>
> (remove ^^ from email address)
>
> Portland, Oregon
>
>
>
>
> "Andrew" <[email protected]> wrote in message
> news:[email protected]...
> >I know that, but t does not work
> > a b c
> > 1 7:30 17:30 10.00
> > 2 7:30 17:30 10.00
> > 3 7:30 10:30 3.00
> > 4 7:15 17:30 10.25
> > 5 7:15 17:30 10.25
> >
> > #VALUE!
> >
> >
> > Formula for c3 is =(b1-a1)*24
> >
> > hope ths helps
> >
> > "Peo Sjoblom" wrote:
> >
> >> Just use =SUM(C1:C?)
> >>
> >> where C? is the last cell with data that you want to include
> >>
> >> --
> >>
> >> Regards,
> >>
> >> Peo Sjoblom
> >>
> >> Northwest Excel Solutions
> >>
> >> www.nwexcelsolutions.com
> >>
> >> (remove ^^ from email address)
> >>
> >> Portland, Oregon
> >>
> >>
> >>
> >>
> >> "Andrew" <[email protected]> wrote in message
> >> news:[email protected]...
> >> >I need each row to have its own total, and then have a total at the
> >> >bottem
> >> >of
> >> > each column.
> >> >
> >> > "Peo Sjoblom" wrote:
> >> >
> >> >> Maybe Andrew meant something like this in C2 so the values accumulate
> >> >>
> >> >> =(B2-A2)*24+C1
> >> >>
> >> >> and copy down
> >> >>
> >> >> --
> >> >>
> >> >> Regards,
> >> >>
> >> >> Peo Sjoblom
> >> >>
> >> >> Northwest Excel Solutions
> >> >>
> >> >> www.nwexcelsolutions.com
> >> >>
> >> >> (remove ^^ from email address)
> >> >>
> >> >> Portland, Oregon
> >> >>
> >> >>
> >> >>
> >> >>
> >> >> "Bob Phillips" <[email protected]> wrote in message
> >> >> news:[email protected]...
> >> >> > As they are just decimal numbers now, they should simply add up.
> >> >> > What
> >> >> > is
> >> >> > the
> >> >> > problem you get, give an example?
> >> >> >
> >> >> > --
> >> >> > HTH
> >> >> >
> >> >> > Bob Phillips
> >> >> >
> >> >> > (remove nothere from email address if mailing direct)
> >> >> >
> >> >> > "Andrew" <[email protected]> wrote in message
> >> >> > news:[email protected]...
> >> >> >> I'm not sure what you mean, sorry...
> >> >> >>
> >> >> >> "Gary''s Student" wrote:
> >> >> >>
> >> >> >> > Try formatting the sum as;
> >> >> >> >
> >> >> >> > [h]:mm
> >> >> >> > --
> >> >> >> > Gary's Student
> >> >> >> >
> >> >> >> >
> >> >> >> > "Andrew" wrote:
> >> >> >> >
> >> >> >> > > I have created a formula for calculating total hours / day
> >> >> >> > > the times are entered in military time
> >> >> >> > > a1 = 7:30, b1 = 15:30, c1= =(b1-a1)*24, and it works great,
> >> >> >> > > however I
> >> >> > can
> >> >> >> > > not get those numbers in the C colum to add up for a rolling
> >> >> >> > > total
> >> >> >> > >
> >> >> >> > > HELP !!!!!
> >> >> >
> >> >> >
> >> >>
> >> >>
> >>
> >>
>
>

[Peo Sjoblom]

The only way you can get a value error is if you calculate something seen as
text and if C1:C5 are all numbers then you can not get an error, if any
value in A1:A5 or B1:B5 are text then you can get a value error in C1:C5 and
if you get one there then the sum will return the error as well, what
happens if you use

=SUMIF(C1:C5,"<>#VALUE!")

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"Andrew" <[email protected]> wrote in message
news:[email protected]...
> That's correct
>
> "Peo Sjoblom" wrote:
>
>> Are you saying that if you use
>>
>> =SUM(C1:C5)
>>
>> you'll get a value error?
>>
>>
>>
>> --
>>
>> Regards,
>>
>> Peo Sjoblom
>>
>> Northwest Excel Solutions
>>
>> www.nwexcelsolutions.com
>>
>> (remove ^^ from email address)
>>
>> Portland, Oregon
>>
>>
>>
>>
>> "Andrew" <[email protected]> wrote in message
>> news:[email protected]...
>> >I know that, but t does not work
>> > a b c
>> > 1 7:30 17:30 10.00
>> > 2 7:30 17:30 10.00
>> > 3 7:30 10:30 3.00
>> > 4 7:15 17:30 10.25
>> > 5 7:15 17:30 10.25
>> >
>> > #VALUE!
>> >
>> >
>> > Formula for c3 is =(b1-a1)*24
>> >
>> > hope ths helps
>> >
>> > "Peo Sjoblom" wrote:
>> >
>> >> Just use =SUM(C1:C?)
>> >>
>> >> where C? is the last cell with data that you want to include
>> >>
>> >> --
>> >>
>> >> Regards,
>> >>
>> >> Peo Sjoblom
>> >>
>> >> Northwest Excel Solutions
>> >>
>> >> www.nwexcelsolutions.com
>> >>
>> >> (remove ^^ from email address)
>> >>
>> >> Portland, Oregon
>> >>
>> >>
>> >>
>> >>
>> >> "Andrew" <[email protected]> wrote in message
>> >> news:[email protected]...
>> >> >I need each row to have its own total, and then have a total at the
>> >> >bottem
>> >> >of
>> >> > each column.
>> >> >
>> >> > "Peo Sjoblom" wrote:
>> >> >
>> >> >> Maybe Andrew meant something like this in C2 so the values
>> >> >> accumulate
>> >> >>
>> >> >> =(B2-A2)*24+C1
>> >> >>
>> >> >> and copy down
>> >> >>
>> >> >> --
>> >> >>
>> >> >> Regards,
>> >> >>
>> >> >> Peo Sjoblom
>> >> >>
>> >> >> Northwest Excel Solutions
>> >> >>
>> >> >> www.nwexcelsolutions.com
>> >> >>
>> >> >> (remove ^^ from email address)
>> >> >>
>> >> >> Portland, Oregon
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >> "Bob Phillips" <[email protected]> wrote in message
>> >> >> news:[email protected]...
>> >> >> > As they are just decimal numbers now, they should simply add up.
>> >> >> > What
>> >> >> > is
>> >> >> > the
>> >> >> > problem you get, give an example?
>> >> >> >
>> >> >> > --
>> >> >> > HTH
>> >> >> >
>> >> >> > Bob Phillips
>> >> >> >
>> >> >> > (remove nothere from email address if mailing direct)
>> >> >> >
>> >> >> > "Andrew" <[email protected]> wrote in message
>> >> >> > news:[email protected]...
>> >> >> >> I'm not sure what you mean, sorry...
>> >> >> >>
>> >> >> >> "Gary''s Student" wrote:
>> >> >> >>
>> >> >> >> > Try formatting the sum as;
>> >> >> >> >
>> >> >> >> > [h]:mm
>> >> >> >> > --
>> >> >> >> > Gary's Student
>> >> >> >> >
>> >> >> >> >
>> >> >> >> > "Andrew" wrote:
>> >> >> >> >
>> >> >> >> > > I have created a formula for calculating total hours / day
>> >> >> >> > > the times are entered in military time
>> >> >> >> > > a1 = 7:30, b1 = 15:30, c1= =(b1-a1)*24, and it works great,
>> >> >> >> > > however I
>> >> >> > can
>> >> >> >> > > not get those numbers in the C colum to add up for a rolling
>> >> >> >> > > total
>> >> >> >> > >
>> >> >> >> > > HELP !!!!!
>> >> >> >
>> >> >> >
>> >> >>
>> >> >>
>> >>
>> >>
>>
>>

[protonLeah]

Assuming that the first seven rows of column A hold the day names, i.e., Mon, Tues, etc. then:

1. The first seven cells in columns B, C & D should be formatted for 24 hour time (13:30)
2. The first seven cells in column D would contain the formula:
   =IF(C1>B1,SUM(C1-B1),SUM(C1+24-B1)) "time worked in hrs and mins"
3. The cells of column E would be formatted as number, say 1 decimal place, and contain the formula:
   =SUM(HOUR(D1),(MINUTE(D1)/60)) "time worked in hours and tenths
4. Cell E8 would simply sum E1:E7 for the weekly total in hours and tenths.

[Ron]

I've have the same thing. I have built a spreedsheet to kept track of my
hours worked. I go in at 21:45 each nite and get off at 06:00. I can not get
the spreedsheet to total the hours. Every outher week I have to work over, I
go in
at 21:45, but I don't get off until 14:00 the next day, for a total of
16:15. I NEED
HELP WITH THIS ONE PLEASE.
--
ironmn


"Andrew" wrote:

> I have created a formula for calculating total hours / day
> the times are entered in military time
> a1 = 7:30, b1 = 15:30, c1= =(b1-a1)*24, and it works great, however I can
> not get those numbers in the C colum to add up for a rolling total
>
> HELP !!!!!

[Daniel CHEN]

=(B1-A1)*24+24*IF(B1>A1,0,1)

--
Best regards,
---
Yongjun CHEN
==================================
- - - - www.XLDataSoft.com - - - -
Free Excel/VBA Tool & Training Material
==================================
"Ron" <[email protected]> wrote in message
news:[email protected]...
> I've have the same thing. I have built a spreedsheet to kept track of my
> hours worked. I go in at 21:45 each nite and get off at 06:00. I can not
> get
> the spreedsheet to total the hours. Every outher week I have to work
> over, I
> go in
> at 21:45, but I don't get off until 14:00 the next day, for a total of
> 16:15. I NEED
> HELP WITH THIS ONE PLEASE.
> --
> ironmn
>
>
> "Andrew" wrote:
>
>> I have created a formula for calculating total hours / day
>> the times are entered in military time
>> a1 = 7:30, b1 = 15:30, c1= =(b1-a1)*24, and it works great, however I can
>> not get those numbers in the C colum to add up for a rolling total
>>
>> HELP !!!!!

[Roger Govier]

Hi Ron

With clock on in A1 and clock off in B1 try
=MOD(B1-A1,1)

--
Regards

Roger Govier


"Ron" <[email protected]> wrote in message
news:[email protected]...
> I've have the same thing. I have built a spreedsheet to kept track of
> my
> hours worked. I go in at 21:45 each nite and get off at 06:00. I can
> not get
> the spreedsheet to total the hours. Every outher week I have to work
> over, I
> go in
> at 21:45, but I don't get off until 14:00 the next day, for a total of
> 16:15. I NEED
> HELP WITH THIS ONE PLEASE.
> --
> ironmn
>
>
> "Andrew" wrote:
>
>> I have created a formula for calculating total hours / day
>> the times are entered in military time
>> a1 = 7:30, b1 = 15:30, c1= =(b1-a1)*24, and it works great, however I
>> can
>> not get those numbers in the C colum to add up for a rolling total
>>
>> HELP !!!!!

[Ron]

Roger, I would like to email you my time sheet so you can see if you can
help. I need your email address or a place where I can send this. Ron
(IRONMN)
--
ironmn


"Roger Govier" wrote:

> Hi Ron
>
> With clock on in A1 and clock off in B1 try
> =MOD(B1-A1,1)
>
> --
> Regards
>
> Roger Govier
>
>
> "Ron" <[email protected]> wrote in message
> news:[email protected]...
> > I've have the same thing. I have built a spreedsheet to kept track of
> > my
> > hours worked. I go in at 21:45 each nite and get off at 06:00. I can
> > not get
> > the spreedsheet to total the hours. Every outher week I have to work
> > over, I
> > go in
> > at 21:45, but I don't get off until 14:00 the next day, for a total of
> > 16:15. I NEED
> > HELP WITH THIS ONE PLEASE.
> > --
> > ironmn
> >
> >
> > "Andrew" wrote:
> >
> >> I have created a formula for calculating total hours / day
> >> the times are entered in military time
> >> a1 = 7:30, b1 = 15:30, c1= =(b1-a1)*24, and it works great, however I
> >> can
> >> not get those numbers in the C colum to add up for a rolling total
> >>
> >> HELP !!!!!
>
>
>

[Roger Govier]

Hi Ron

Send the file to roger dot govier at technology4u dot co dot uk

Do the obvious things with dot and at

--
Regards

Roger Govier


"Ron" <[email protected]> wrote in message
news:[email protected]...
> Roger, I would like to email you my time sheet so you can see if you
> can
> help. I need your email address or a place where I can send this. Ron
> (IRONMN)
> --
> ironmn
>
>
> "Roger Govier" wrote:
>
>> Hi Ron
>>
>> With clock on in A1 and clock off in B1 try
>> =MOD(B1-A1,1)
>>
>> --
>> Regards
>>
>> Roger Govier
>>
>>
>> "Ron" <[email protected]> wrote in message
>> news:[email protected]...
>> > I've have the same thing. I have built a spreedsheet to kept track
>> > of
>> > my
>> > hours worked. I go in at 21:45 each nite and get off at 06:00. I
>> > can
>> > not get
>> > the spreedsheet to total the hours. Every outher week I have to
>> > work
>> > over, I
>> > go in
>> > at 21:45, but I don't get off until 14:00 the next day, for a total
>> > of
>> > 16:15. I NEED
>> > HELP WITH THIS ONE PLEASE.
>> > --
>> > ironmn
>> >
>> >
>> > "Andrew" wrote:
>> >
>> >> I have created a formula for calculating total hours / day
>> >> the times are entered in military time
>> >> a1 = 7:30, b1 = 15:30, c1= =(b1-a1)*24, and it works great,
>> >> however I
>> >> can
>> >> not get those numbers in the C colum to add up for a rolling total
>> >>
>> >> HELP !!!!!
>>
>>
>>

[Ron]

Roger, Hi, i was just checking to see if you got it. Ron
--
ironmn


"Roger Govier" wrote:

> Hi Ron
>
> Send the file to roger dot govier at technology4u dot co dot uk
>
> Do the obvious things with dot and at
>
> --
> Regards
>
> Roger Govier
>
>
> "Ron" <[email protected]> wrote in message
> news:[email protected]...
> > Roger, I would like to email you my time sheet so you can see if you
> > can
> > help. I need your email address or a place where I can send this. Ron
> > (IRONMN)
> > --
> > ironmn
> >
> >
> > "Roger Govier" wrote:
> >
> >> Hi Ron
> >>
> >> With clock on in A1 and clock off in B1 try
> >> =MOD(B1-A1,1)
> >>
> >> --
> >> Regards
> >>
> >> Roger Govier
> >>
> >>
> >> "Ron" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > I've have the same thing. I have built a spreedsheet to kept track
> >> > of
> >> > my
> >> > hours worked. I go in at 21:45 each nite and get off at 06:00. I
> >> > can
> >> > not get
> >> > the spreedsheet to total the hours. Every outher week I have to
> >> > work
> >> > over, I
> >> > go in
> >> > at 21:45, but I don't get off until 14:00 the next day, for a total
> >> > of
> >> > 16:15. I NEED
> >> > HELP WITH THIS ONE PLEASE.
> >> > --
> >> > ironmn
> >> >
> >> >
> >> > "Andrew" wrote:
> >> >
> >> >> I have created a formula for calculating total hours / day
> >> >> the times are entered in military time
> >> >> a1 = 7:30, b1 = 15:30, c1= =(b1-a1)*24, and it works great,
> >> >> however I
> >> >> can
> >> >> not get those numbers in the C colum to add up for a rolling total
> >> >>
> >> >> HELP !!!!!
> >>
> >>
> >>
>
>
>

[Roger Govier]

Hi Ron

File received and on its way back.
Your problem was not in the calculation of time from start to finish.
Excel stores times as fractions of a day, so before you multiply the
hours worked by the dollar rate, you need to multiply by 24 (hours per
day) to convert to decimal hours.
In order for the correct result to display, the cell with this
calculation needs to be formatted as General or Number (not Time).

--
Regards

Roger Govier


"Ron" <[email protected]> wrote in message
news:[email protected]...
> Roger, Hi, i was just checking to see if you got it. Ron
> --
> ironmn
>
>
> "Roger Govier" wrote:
>
>> Hi Ron
>>
>> Send the file to roger dot govier at technology4u dot co dot uk
>>
>> Do the obvious things with dot and at
>>
>> --
>> Regards
>>
>> Roger Govier
>>
>>
>> "Ron" <[email protected]> wrote in message
>> news:[email protected]...
>> > Roger, I would like to email you my time sheet so you can see if
>> > you
>> > can
>> > help. I need your email address or a place where I can send this.
>> > Ron
>> > (IRONMN)
>> > --
>> > ironmn
>> >
>> >
>> > "Roger Govier" wrote:
>> >
>> >> Hi Ron
>> >>
>> >> With clock on in A1 and clock off in B1 try
>> >> =MOD(B1-A1,1)
>> >>
>> >> --
>> >> Regards
>> >>
>> >> Roger Govier
>> >>
>> >>
>> >> "Ron" <[email protected]> wrote in message
>> >> news:[email protected]...
>> >> > I've have the same thing. I have built a spreedsheet to kept
>> >> > track
>> >> > of
>> >> > my
>> >> > hours worked. I go in at 21:45 each nite and get off at 06:00. I
>> >> > can
>> >> > not get
>> >> > the spreedsheet to total the hours. Every outher week I have to
>> >> > work
>> >> > over, I
>> >> > go in
>> >> > at 21:45, but I don't get off until 14:00 the next day, for a
>> >> > total
>> >> > of
>> >> > 16:15. I NEED
>> >> > HELP WITH THIS ONE PLEASE.
>> >> > --
>> >> > ironmn
>> >> >
>> >> >
>> >> > "Andrew" wrote:
>> >> >
>> >> >> I have created a formula for calculating total hours / day
>> >> >> the times are entered in military time
>> >> >> a1 = 7:30, b1 = 15:30, c1= =(b1-a1)*24, and it works great,
>> >> >> however I
>> >> >> can
>> >> >> not get those numbers in the C colum to add up for a rolling
>> >> >> total
>> >> >>
>> >> >> HELP !!!!!
>> >>
>> >>
>> >>
>>
>>
>>

[Marisel]

Hi Chen,
Thank you very much! I have been looking for that formula I while ago. I
tried and it helped. Thanks!

"Daniel CHEN" wrote:

> =(B1-A1)*24+24*IF(B1>A1,0,1)
>
> --
> Best regards,
> ---
> Yongjun CHEN
> ==================================
> - - - - www.XLDataSoft.com - - - -
> Free Excel/VBA Tool & Training Material
> ==================================
> "Ron" <[email protected]> wrote in message
> news:[email protected]...
> > I've have the same thing. I have built a spreedsheet to kept track of my
> > hours worked. I go in at 21:45 each nite and get off at 06:00. I can not
> > get
> > the spreedsheet to total the hours. Every outher week I have to work
> > over, I
> > go in
> > at 21:45, but I don't get off until 14:00 the next day, for a total of
> > 16:15. I NEED
> > HELP WITH THIS ONE PLEASE.
> > --
> > ironmn
> >
> >
> > "Andrew" wrote:
> >
> >> I have created a formula for calculating total hours / day
> >> the times are entered in military time
> >> a1 = 7:30, b1 = 15:30, c1= =(b1-a1)*24, and it works great, however I can
> >> not get those numbers in the C colum to add up for a rolling total
> >>
> >> HELP !!!!!
>
>
>