Discussion Time Formatting in Excel
https://techcommunity.microsoft.com/t5/excel/time-formatting/m-p/1844079#M79734
<P>If Cell A1 contains 8:00 AM and Cell B1 contains 3:00 PM and I wanted to know the difference between those two times inorder to calculate the total hours worked. As Im well aware of the fact that Excel consider Time 8:00 AM as 8/24 and for 3:00PM as (12+3)/24 so to get my answer as '7 ' I used the formula</P><P> </P><P><STRONG>(B1-A1)*24 </STRONG></P><P><EM>decides to mutiply by 24 get to get the number 7</EM></P><P> </P><P>But everytime when I used the above formula my answer always comes as 12:00 AM instead of 7</P><P>so I Click on the cell that I entered my formula and click General in Number formatting and when I do that I get the desired asnwer(7).</P><P> </P><P>Just wanted to know if there's a way to get the answer as 7 without clicking eveytime on the cell to change it to general? As I dont understand Why I have to change to general each time? </P>Mon, 02 Nov 2020 11:58:04 GMTkafka422020-11-02T11:58:04ZTime Formatting
https://techcommunity.microsoft.com/t5/excel/time-formatting/m-p/1844079#M79734
<P>If Cell A1 contains 8:00 AM and Cell B1 contains 3:00 PM and I wanted to know the difference between those two times inorder to calculate the total hours worked. As Im well aware of the fact that Excel consider Time 8:00 AM as 8/24 and for 3:00PM as (12+3)/24 so to get my answer as '7 ' I used the formula</P><P> </P><P><STRONG>(B1-A1)*24 </STRONG></P><P><EM>decides to mutiply by 24 get to get the number 7</EM></P><P> </P><P>But everytime when I used the above formula my answer always comes as 12:00 AM instead of 7</P><P>so I Click on the cell that I entered my formula and click General in Number formatting and when I do that I get the desired asnwer(7).</P><P> </P><P>Just wanted to know if there's a way to get the answer as 7 without clicking eveytime on the cell to change it to general? As I dont understand Why I have to change to general each time? </P>Mon, 02 Nov 2020 11:58:04 GMThttps://techcommunity.microsoft.com/t5/excel/time-formatting/m-p/1844079#M79734kafka422020-11-02T11:58:04ZRe: Time Formatting
https://techcommunity.microsoft.com/t5/excel/time-formatting/m-p/1844141#M79737
<P><LI-USER uid="840530"></LI-USER> </P>
<P>The formula =B1-A1 subtracts two times and returns the result as time, which is reasonable.</P>
<P>Sometimes, you want to multiply this, for example to take overtime into account. For example, if time on Sunday counts double: =(B1-A1)*2. It is still reasonable to display this as time.</P>
<P>So it's difficult for Excel to "know" that you DON'T want =(B1-A1)*24 to display as time.</P>Mon, 02 Nov 2020 12:25:10 GMThttps://techcommunity.microsoft.com/t5/excel/time-formatting/m-p/1844141#M79737Hans Vogelaar2020-11-02T12:25:10ZRe: Time Formatting
https://techcommunity.microsoft.com/t5/excel/time-formatting/m-p/1845653#M79788
Thanks for your clarification!! Really helpful.Mon, 02 Nov 2020 18:30:36 GMThttps://techcommunity.microsoft.com/t5/excel/time-formatting/m-p/1845653#M79788kafka422020-11-02T18:30:36Z