negative time in Hours and mins
is there a way i can show negative time eg needs to work 3:00 hours but only
works 2:00 hours it will come up as -1:00hours but if then they do an extra 2:00 hours it will show 1:00 |
negative time in Hours and mins
With hours to work in A1 and
actual worked in B1 try the below formula in C1 =IF(B1=A1,B1-A1,"-"&TEXT(ABS(B1-A1),"hh:mm")) PS: This is only for display and not for calculations; as excel do not display negative time.. If this post helps click Yes --------------- Jacob Skaria "Matt" wrote: is there a way i can show negative time eg needs to work 3:00 hours but only works 2:00 hours it will come up as -1:00hours but if then they do an extra 2:00 hours it will show 1:00 |
negative time in Hours and mins
"Matt" wrote in message ... is there a way i can show negative time eg needs to work 3:00 hours but only works 2:00 hours it will come up as -1:00hours but if then they do an extra 2:00 hours it will show 1:00 Hi Matt. The [h] formatting can show negative hours. But you can not have negative minutes shown also. Try this user formatting [h]:mm;-[h]:-- It will show 3:00 for the positives, and -1:-- for the negatives. When only the format is fiddled with, the underlying numbers don't change, and can be used in further calculations. Hans T. |
All times are GMT +1. The time now is 08:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com