| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
|
#4
|
|||
|
|||
|
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? |
|
#5
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating time difference over midnight! | Excel Discussion (Misc queries) | |||
| Excel Time Manipulation | Excel Discussion (Misc queries) | |||
| Calculating time difference | Excel Discussion (Misc queries) | |||
| Calculating Time in XP takes forever | Excel Discussion (Misc queries) | |||
| Calculating time between successful data transmissions | Excel Discussion (Misc queries) | |||
Hybrid Mode
