How do I write Excel formula for start 4am, end 12:35 pm, minus 30 minutes Thanks Pete
L Learning Jan 11, 2008 #1 How do I write Excel formula for start 4am, end 12:35 pm, minus 30 minutes Thanks Pete
J JE McGimpsey Jan 11, 2008 #2 XL stores times as fractional days, so one way: =TIME(12,35,0) - TIME(4, 0, 0) - TIME(0, 30, 0) another: A1: 04:00 am A2: 12:35 pm A3: =A2-A1-TIME(0,30,0) format A3 as a time, if necessary. If the times may span midnight, use =MOD(A2-A1-TIME(0,30,0),1)
XL stores times as fractional days, so one way: =TIME(12,35,0) - TIME(4, 0, 0) - TIME(0, 30, 0) another: A1: 04:00 am A2: 12:35 pm A3: =A2-A1-TIME(0,30,0) format A3 as a time, if necessary. If the times may span midnight, use =MOD(A2-A1-TIME(0,30,0),1)
