Hello everybody,
I would like to ask you something that until now I haven’t found any answer. Official Microsoft says that it can’t be done. But honestly I must find a solution asap. As my boss said.
I have an exported excel sheet from the SAP system. Then I have to import this file to an Access Database and produce a numerous reports. The title of the program is “Time Management” in case you wonder.
Now the problem is that I have to subtract fields with“time” data type in order to calculate over hours. But what happens if the value is negative ?
Example:
All the employees start 9:00 and go home at 17:00. So if the employee one day stopped working at 17:30 his over hour is 30 minutes. The next day If he stopped working at 16:20 for some reason then I have to subtract 30mins-40mins, and the final over hour is -10 minutes.
So annual Over Hours = Over Hours – (Time that has left earlier).
So the questions is what I have to do if a have an employee with negative time ? In excel you can’t have negative time. But I need a number to do the calculations.
Thank you so much. Your help would be highly appreciated.
I would like to ask you something that until now I haven’t found any answer. Official Microsoft says that it can’t be done. But honestly I must find a solution asap. As my boss said.
I have an exported excel sheet from the SAP system. Then I have to import this file to an Access Database and produce a numerous reports. The title of the program is “Time Management” in case you wonder.
Now the problem is that I have to subtract fields with“time” data type in order to calculate over hours. But what happens if the value is negative ?
Example:
All the employees start 9:00 and go home at 17:00. So if the employee one day stopped working at 17:30 his over hour is 30 minutes. The next day If he stopped working at 16:20 for some reason then I have to subtract 30mins-40mins, and the final over hour is -10 minutes.
So annual Over Hours = Over Hours – (Time that has left earlier).
So the questions is what I have to do if a have an employee with negative time ? In excel you can’t have negative time. But I need a number to do the calculations.
Thank you so much. Your help would be highly appreciated.