7:00am int A1, 3:00pm in B1. When I (B1 - A1) I get 0.33 but I want 8. Thoughts?
E Emerogork via OfficeKB.com Sep 2, 2007 #1 7:00am int A1, 3:00pm in B1. When I (B1 - A1) I get 0.33 but I want 8. Thoughts?
J JE McGimpsey Sep 2, 2007 #2 XL stores times as fractional days, so multiply by 24 hours per day to get hours: =(B1-A1) * 24
S Stan Brown Sep 2, 2007 #3 Sun, 02 Sep 2007 07:30:51 GMT from Emerogork via OfficeKB.com <u36894 @uwe>: 7:00am int A1, 3:00pm in B1. When I (B1 - A1) I get 0.33 but I want 8. Thoughts? Click to expand... The subtraction gives you fractions of a day. Multiply by 24 to get hours and fractions of an hour. If you want only whole hours, use INT() or ROUND() on the result.
Sun, 02 Sep 2007 07:30:51 GMT from Emerogork via OfficeKB.com <u36894 @uwe>: 7:00am int A1, 3:00pm in B1. When I (B1 - A1) I get 0.33 but I want 8. Thoughts? Click to expand... The subtraction gives you fractions of a day. Multiply by 24 to get hours and fractions of an hour. If you want only whole hours, use INT() or ROUND() on the result.
