close

Help please.
I am trying to add times together. Like a clock card.
The times are split in hours and mins but the total will add upto more than
24hrs.
ex. 9 hrs 34 mins 13hrs 34 mins 12 hrs 51 mins.
I am not particularly great with spreadsheets so any advice in very basic
terms please.
Thanks

JackieJust add the two cells, but format the result cell (Formatgt;Cellsgt;Custom) as
[h]:mm

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;suicidal jackiequot; lt;suicidal gt; wrote in
message ...
gt; Help please.
gt; I am trying to add times together. Like a clock card.
gt; The times are split in hours and mins but the total will add upto more
than
gt; 24hrs.
gt; ex. 9 hrs 34 mins 13hrs 34 mins 12 hrs 51 mins.
gt; I am not particularly great with spreadsheets so any advice in very basic
gt; terms please.
gt; Thanks
gt;
gt; Jackie
gt;

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

    software

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