i want to figure out the hours between two different times even if they go into the next day ?
B bmg Feb 21, 2006 #1 i want to figure out the hours between two different times even if they go into the next day ?
P Peo Sjoblom Feb 21, 2006 #2 start time in A1 and end time in B1 =MOD(B1-A1,1) or =B1-A1+(A1>B1) -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon
start time in A1 and end time in B1 =MOD(B1-A1,1) or =B1-A1+(A1>B1) -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon
R Ron Rosenfeld Feb 21, 2006 #3 i want to figure out the hours between two different times even if they go into the next day ? Click to expand... A1: 2/6/06 7:00 A2: 2/9/06 4:45 =A2-A1 Format/Cells/Number Custom Type: [h] -->69 --ron
i want to figure out the hours between two different times even if they go into the next day ? Click to expand... A1: 2/6/06 7:00 A2: 2/9/06 4:45 =A2-A1 Format/Cells/Number Custom Type: [h] -->69 --ron
B Biff Feb 21, 2006 #4 Hi! If the difference is 24 hours or more, you'll have to include dates. Examples: A1 = 6:00 PM B1 = 11:00 AM (next day) Formula: format the cell as [h]:mm =B1-A1+(B1<A1) Returns 17:00 A1 = 2/20/2006 6:00 PM B1 = 2/21/2006 7:00 PM Returns 25:00 Biff
Hi! If the difference is 24 hours or more, you'll have to include dates. Examples: A1 = 6:00 PM B1 = 11:00 AM (next day) Formula: format the cell as [h]:mm =B1-A1+(B1<A1) Returns 17:00 A1 = 2/20/2006 6:00 PM B1 = 2/21/2006 7:00 PM Returns 25:00 Biff
