How do you set up a calculation to compute hours when the shift goes from 11:
p.m. to 7: a.m. Normal calculations won't work in this case.
How do you set up a calculation to compute hours when the shift goes from 11:
p.m. to 7: a.m. Normal calculations won't work in this case.
Direct subtraction should work if you tell Excel that the times are for
different dates:
In A1, A2:
9/11/05 11:00 PM
9/12/05 7:00 AM
In A3 put:
=A2-A1 and format as hh:mm and you will see:
8:00
--
Gary''s Student
"Steve" wrote:
> How do you set up a calculation to compute hours when the shift goes from 11:
> p.m. to 7: a.m. Normal calculations won't work in this case.
check contexture's or chip pearson's page
http://www.contextures.com/xlfaqDat.html
http://www.cpearson.com/excel/datearith.htm
--
Gary
"Steve" <[email protected]> wrote in message
news:[email protected]...
> How do you set up a calculation to compute hours when the shift goes from
> 11:
> p.m. to 7: a.m. Normal calculations won't work in this case.
and just in addition...
if you format a3 as a number, multiply it by 24, =(a2-a1)*24, just in case
you want to figure out an hourly wage, for example.
--
Gary
"Gary''s Student" <[email protected]> wrote in message
news:[email protected]...
> Direct subtraction should work if you tell Excel that the times are for
> different dates:
> In A1, A2:
>
> 9/11/05 11:00 PM
> 9/12/05 7:00 AM
>
> In A3 put:
> =A2-A1 and format as hh:mm and you will see:
>
> 8:00
> --
> Gary''s Student
>
>
> "Steve" wrote:
>
>> How do you set up a calculation to compute hours when the shift goes from
>> 11:
>> p.m. to 7: a.m. Normal calculations won't work in this case.
=MOD(E7-D7,1)
Assume Start time is in D7 and End time in E7. Format the cell as Time
--
Regards,
Tom Ogilvy
"Steve" <[email protected]> wrote in message
news:[email protected]...
> How do you set up a calculation to compute hours when the shift goes from
11:
> p.m. to 7: a.m. Normal calculations won't work in this case.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks