# calculating hours and minutes for a timesheet

1. ## calculating hours and minutes for a timesheet

I might be missing something obvious here, this seems like a relatively simple task but I am not getting the right calculations.
How do I calculate Column E to just total the hours and minutes worked (from column C and D) in this attached timesheet?

2. ## Re: calculating hours and minutes for a timesheet

Should it not be...
=D4-C4

?

3. ## Re: calculating hours and minutes for a timesheet

lol yes,thanks

4. ## Re: calculating hours and minutes for a timesheet

How would I total the hours and minutes in cell f1 given the hourly rate of \$100?

5. ## Re: calculating hours and minutes for a timesheet

Do you mean...?
=E1*24*H1

Edit: Oh and I'd recommend using [h]:mm format on E1 instead of h:mm. [h] allows display of hours greater than 23.

6. ## Re: calculating hours and minutes for a timesheet

Thanks, where did the 24 come from?

7. ## Re: calculating hours and minutes for a timesheet

In Excel time is stored as decimal value. And 1 hour =1/24.
So to convert it back to hour value you multiply by 24.

8. ## Re: calculating hours and minutes for a timesheet

Great ok, thanks so much

There are currently 1 users browsing this thread. (0 members and 1 guests)