Help!

Calculate hour and minutes worked each day

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> New Users RSS
Next:  opening multiple windows at once?  
Author Message
Allan
External


Since: Oct 27, 2004
Posts: 49



PostPosted: Tue Nov 15, 2005 1:02 am    Post subject: Calculate hour and minutes worked each day
Archived from groups: microsoft>public>excel>newusers (more info?)

As a novice to Excel I am trying to work out a formula to calculate hours and
minutes worked each day (start and finish) and then at the end of the week
add these times to calculate weekly salary.
Back to top
R.VENKATARAMAN
External


Since: Mar 04, 2005
Posts: 199



PostPosted: Tue Nov 15, 2005 5:15 am    Post subject: Re: Calculate hour and minutes worked each day [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

if a2 isthe start time and B2 is end time in c2 type thisformula
=IF(B3-A3<0,B3-A3+24,B3-A3)
format C2 as time
your can copy this file down keeping the format in column C as Time

====================
"Allan" wrote in message

> As a novice to Excel I am trying to work out a formula to calculate hours
and
> minutes worked each day (start and finish) and then at the end of the week
> add these times to calculate weekly salary.
Back to top
Biff
External


Since: Dec 09, 2004
Posts: 3582



PostPosted: Tue Nov 15, 2005 5:15 am    Post subject: Re: Calculate hour and minutes worked each day [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Try this instead:

If you want the result in time: 8:00, format the cell as [h]:mm

=B3-A3+(B3<A3)

If you want the result in decimal: 8

=(B3-A3+(B3<A3))*24

Biff

"R.VENKATARAMAN" wrote in message

> if a2 isthe start time and B2 is end time in c2 type thisformula
> =IF(B3-A3<0,B3-A3+24,B3-A3)
> format C2 as time
> your can copy this file down keeping the format in column C as Time
>
> ====================
> "Allan" wrote in message
>
>> As a novice to Excel I am trying to work out a formula to calculate hours
> and
>> minutes worked each day (start and finish) and then at the end of the
>> week
>> add these times to calculate weekly salary.
>
>
Back to top
David McRitchie
External


Since: Jul 28, 2005
Posts: 1688



PostPosted: Sat Nov 19, 2005 10:32 pm    Post subject: Re: Calculate hour and minutes worked each day [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

One more thing when totaling time in the hh:mm format
you want to use [h]:mm to keep the hour from overflowing
into days. when you want to convert to a decimal number
with fractional decimals multiply by 24 and format as a number.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Biff" wrote in message
> Try this instead:
>
> If you want the result in time: 8:00, format the cell as [h]:mm
>
> =B3-A3+(B3<A3)
>
> If you want the result in decimal: 8
>
> =(B3-A3+(B3<A3))*24
>
> Biff
>
> "R.VENKATARAMAN" wrote in message
>
> > if a2 isthe start time and B2 is end time in c2 type thisformula
> > =IF(B3-A3<0,B3-A3+24,B3-A3)
> > format C2 as time
> > your can copy this file down keeping the format in column C as Time
> >
> > ====================
> > "Allan" wrote in message
> >
> >> As a novice to Excel I am trying to work out a formula to calculate hours
> > and
> >> minutes worked each day (start and finish) and then at the end of the
> >> week
> >> add these times to calculate weekly salary.
> >
> >
>
>
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> New Users All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum