we work 8hrs 30mns for 4 days
7hrs 30mns for 1 day
this is monday to friday
using Excel i need a formula that will add the following:-
a1 8.30
a2 8.30
a3 8.30
a4 8.30
a5 7.30
total 41.30
i have not used Excel for a couple of years and am a bit rusty and would appreciate any help.
many thanks
pink pig
Last edited by oldchippy; 05-04-2009 at 09:16 AM.
in A6 =Sum(A1:A5)
EDIT: The cells must be formatted as TIME and the total cell (A6) must be custom formatted [h]:mm
Last edited by Simon Lloyd; 08-03-2008 at 05:42 AM.
Not all forums are the same - seek and you shall find
Hi pink pig,
Welcome to the forum, you may find these links useful?
http://www.cpearson.com/excel/overtime.htm
http://www.j-walk.com/SS/excel/files/timesht.htm
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
thanks
many thanks to both replies.Problem is now sorted.
pink pig
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks