| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate hours without negative
I feel really stupid because I have been reading every post on calculating
hours and trying the formulas but none get me what I want so sorry for this easy post. B2 = Start Time (8:00 AM) C2 = End Time (12:30 PM) D2 = Hours Worked The one formula that gets me closest is: =(B2-C2)*24 however, I get -4.50 and I only want 4.50. I have tried changing to 1904 date system but that didn't seem to do anything. Am I missing something? Thanks!!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate negative hours (time) | Excel Worksheet Functions | |||
| I want to get negative hours if subtraction of hours is negative | Excel Worksheet Functions | |||
| Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis | Excel Discussion (Misc queries) | |||
| Set negative numbers to zero. Do not calculate with negative valu | Excel Discussion (Misc queries) | |||
| How can I show hours of more than 24 & negative hours? | Excel Worksheet Functions | |||
Threaded Mode
