| 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!!!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculate hours without negative
Your formula is backwards.
=(B2-C2)*24 should be =(C2-B2)*24 If there is the possibility that the time period will cross midnight, use =((C2-B2)+(C2<B2))*24 -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "carrietom" wrote in message ... 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!!!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculate hours without negative
Carrie,
Try the reverse: =(C2-B2)*24 See if that works for you. "carrietom" wrote in message ... 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!!!! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculate hours without negative
=(C2-B2)*24 with D2 formatted as General or Number
Latest time less earliest time. Gord Dibben MS Excel MVP On Mon, 22 Oct 2007 16:58:00 -0700, carrietom wrote: 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!!!! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculate hours without negative
Thank you so much - I can't believe I missed that!!!!
"Chip Pearson" wrote: Your formula is backwards. =(B2-C2)*24 should be =(C2-B2)*24 If there is the possibility that the time period will cross midnight, use =((C2-B2)+(C2<B2))*24 -- Cordially, Chip Pearson Microsoft MVP - Excel, 10 Years Pearson Software Consulting www.cpearson.com (email on the web site) "carrietom" wrote in message ... 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!!!! |
| Reply |
| 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 | |||
Linear Mode
