Calculating time worked, using 100ths of hr. (for instance 22.73-06.92). How
do I calculate it correctly since I can't just subtract the end time from the
start time as I do for same day start and stop times?
Calculating time worked, using 100ths of hr. (for instance 22.73-06.92). How
do I calculate it correctly since I can't just subtract the end time from the
start time as I do for same day start and stop times?
How about
=if(endtime>startime, endtime-startime,(endtime+24.0)-startime)
--
Gary's Student
"maintchief" wrote:
> Calculating time worked, using 100ths of hr. (for instance 22.73-06.92). How
> do I calculate it correctly since I can't just subtract the end time from the
> start time as I do for same day start and stop times?
That pluse a minor modification to make sure the time had an entry did the
trick.
Thank you
"Gary''s Student" wrote:
> How about
>
> =if(endtime>startime, endtime-startime,(endtime+24.0)-startime)
> --
> Gary's Student
>
>
> "maintchief" wrote:
>
> > Calculating time worked, using 100ths of hr. (for instance 22.73-06.92). How
> > do I calculate it correctly since I can't just subtract the end time from the
> > start time as I do for same day start and stop times?
You are welcome. If you get the chance, post your minor mode, it may be of
help to others.
--
Gary''s Student
"maintchief" wrote:
> That pluse a minor modification to make sure the time had an entry did the
> trick.
> Thank you
>
> "Gary''s Student" wrote:
>
> > How about
> >
> > =if(endtime>startime, endtime-startime,(endtime+24.0)-startime)
> > --
> > Gary's Student
> >
> >
> > "maintchief" wrote:
> >
> > > Calculating time worked, using 100ths of hr. (for instance 22.73-06.92). How
> > > do I calculate it correctly since I can't just subtract the end time from the
> > > start time as I do for same day start and stop times?
In the minor modification I had to check for '0' time because of days not
worked. If I didn't I would get 24 hours worked.
=IF(endtime>startime,endtime-startime,IF(startime>0,(startime+24)-endtime,0))
"maintchief" wrote:
> That pluse a minor modification to make sure the time had an entry did the
> trick.
> Thank you
>
> "Gary''s Student" wrote:
>
> > How about
> >
> > =if(endtime>startime, endtime-startime,(endtime+24.0)-startime)
> > --
> > Gary's Student
> >
> >
> > "maintchief" wrote:
> >
> > > Calculating time worked, using 100ths of hr. (for instance 22.73-06.92). How
> > > do I calculate it correctly since I can't just subtract the end time from the
> > > start time as I do for same day start and stop times?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks