2007-05-14 02:21:46 · 2 answers · asked by jocelyn c 1 in Computers & Internet ➔ Programming & Design
Use an excel spreadsheet and make it personal.
In cell A1 I typed 08:50
In cell B1 I typed 17:05
In cell C1 I typed =B1-A1
Set the format of cell C1 to be custom and hh:mm
Duplicate this data to suit your needs.
To create a total of hours for month or week just use the SUM(C:C) function.
Set the format of the total cell to be Custom and [h]:mm
You can add days of the week too.
In cell D1 I typed the date
In cell E1 I typed =IF(WEEKDAY(D1)=2, "Monday",IF(WEEKDAY(D1)=3, "Tuesday",IF(WEEKDAY(D1)=4, "Wednesday",IF(WEEKDAY(D1)=5, "Thursday",IF(WEEKDAY(D1)=6, "Friday",IF(WEEKDAY(D1)=7, "Saturday",IF(WEEKDAY(D1)=1, "Sunday")))))))
You may have to remove the spaces that I have added.
All it needs now are boarders and a title.
One spreadsheet per month. or whatever.
2007-05-14 03:39:38 · answer #1 · answered by AnalProgrammer 7 · 0⤊ 0⤋
http://search.yahoo.com/search?p=time+clock+calculator&fr=ush-ans
2007-05-14 07:51:08 · answer #2 · answered by Q&A Answer Mans Retired 7 · 0⤊ 0⤋