Calculating time worked using 100ths of an hour, from 1 day into n
 

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 an hour, from 1 day into n
 

How about

=if(endtimestartime, 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?

Calculating time worked using 100ths of an hour, from 1 day in
 

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(endtimestartime, 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?

Calculating time worked using 100ths of an hour, from 1 day in
 

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(endtimestartime, 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?

Calculating time worked using 100ths of an hour, from 1 day in
 

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(endtimestartime,endtime-startime,IF(startime0,(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(endtimestartime, 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?