close

I am trying to set up a timesheet and find that when my overtime hours reach
more than 24, they automatically change to show the difference to the
24hours. e.g. 27 hours shows as 3 hours. How can I stop this from happening?

Set format as [h]:mm rather than hh:mm. This stops Excel from quot;rolling overquot;
the day.

quot;dvequot; wrote:

gt; I am trying to set up a timesheet and find that when my overtime hours reach
gt; more than 24, they automatically change to show the difference to the
gt; 24hours. e.g. 27 hours shows as 3 hours. How can I stop this from happening?

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()