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.
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.
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" <[email protected]> wrote in message
news:[email protected]...
> 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.
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" <vram26@vsnl$$$.net> wrote in message
news:e%[email protected]...
> 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" <[email protected]> wrote in message
> news:[email protected]...
>> 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.
>
>
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" <[email protected]> wrote in message news:%23TY%[email protected]...
> 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" <vram26@vsnl$$$.net> wrote in message
> news:e%[email protected]...
> > 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" <[email protected]> wrote in message
> > news:[email protected]...
> >> 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.
> >
> >
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks