I want change the time in my worksheet. I need change 3:30 to 3.5 decimals numbers
M Martin Aug 25, 2006 #1 I want change the time in my worksheet. I need change 3:30 to 3.5 decimals numbers
B Bob Phillips Aug 25, 2006 #2 =A1*24 -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct)
J JE McGimpsey Aug 25, 2006 #3 XL times are representable by fractional days, so multiply the time by the number of minutes in a day: A1: 0:03:30 A2: =A1*24*60 ===> 3.5 when formatted as General or Number. A bit more efficiently: A2: =A1*1440
XL times are representable by fractional days, so multiply the time by the number of minutes in a day: A1: 0:03:30 A2: =A1*24*60 ===> 3.5 when formatted as General or Number. A bit more efficiently: A2: =A1*1440
