Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using if statement to subtract 24 hours from time still shows as a negative time from both responses under 24 hours | Excel Worksheet Functions | |||
Adding minutes showing total in hours/minutes, i.e., 60 mins + 60 mins + 15 mins to total of 2 hours 15 mins? | Excel Discussion (Misc queries) | |||
How do I time Hours & mins in excel - Time sheet | Excel Discussion (Misc queries) | |||
Need Time Sheet that calculates hours/mins from input of times | Excel Worksheet Functions | |||
Tracking Time (Hours/Mins) | Excel Discussion (Misc queries) |