Timesheet

P

Pierce Brosnan

I want to make a timesheet which can calculate my income. Have found
severals, but not what I'm looking for.

I want to be able to input my starting, 11:55, and ending 12:00. Then I
want the timesheet to calculate that I have been at work for 5 mins. Have
only found for whole hours, not like 11:27 - 15:53.

Any help appreciated!
 
S

Sandy Mann

The lack of answers makes me think that I must be misreading your question.

With your start time in B2 amd the end in C2 then surely
=C2-B2 formated as time will give you the answer you want.

If you want to sum all the individual times and they are likely to amount to
more then 24 hours then format the total cell as [h]:mm to prevent the hours
rolling over into days at 24 hours.

To calcualte you income then multiply the hours by 24 and then by the wage
rate.

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
[email protected] with @tiscali.co.uk
 
Top