Creating a Time Sheet in Numbers


Recommended Posts

So I've been using Numbers to do a time sheet, but I've been calculating the total time manually. I'm tired of doing that and want Numbers to calculate total times for me. Doing a Google search resulted in this formula "=(End Time - Start Time)*24". What I want it to do is output the number in this format: Z Minutes or X Hours and Y Minutes. Anyone have any idea how to make Numbers do that?

Link to comment
https://www.neowin.net/forum/topic/698688-creating-a-time-sheet-in-numbers/
Share on other sites

I can get it to give a decimal form of the number of hours (ie., 1:30 - 8:45 gives me 7.25 hours) I think that if you want something more detailed, you might have to extract the hours and minutes values and calculate them separately.

I gave it a shot and came up with these formulas:

=MINUTE(TIME(0, ((({End Time} - {Start Time})*24)*60), 0)) --> will give you # of minutes

=HOUR(TIME(0, ((({End Time} - {Start Time})*24)*60), 0)) --> will give you # of Hours

With this formula, if Start Time = 9:55am and End Time = 8:45pm, then my result is

50 minutes and 10 hours, I think this is what you want.

okay, if you want your exact output, use this (an exact copy from my document:

= CONCATENATE(HOUR(TIME(0, (((C8-C7)*24)*60), 0)), " hours and ", MINUTE(TIME(0, (((C8-C7)*24)*60), 0)), " minutes")

Cell C7 = start time

Cell C8 = end time

you can use any cells you want by making appropriate changes to the formula, but this should get you started.

  • 1 year later...

Hi, slacker this changuelo from the US your formula for a time sheet works for a daily time in and time out.

but how would you go about to add the total week hours of each day, I try adding the cell but it wont do it.

can you please help me.

I am doing this for my wife and i need to finish this time sheet for her

i would really appreciate the help thanx.

  On 20/11/2008 at 21:37, Slacker said:

I can get it to give a decimal form of the number of hours (ie., 1:30 - 8:45 gives me 7.25 hours) I think that if you want something more detailed, you might have to extract the hours and minutes values and calculate them separately.

I gave it a shot and came up with these formulas:

=MINUTE(TIME(0, ((({End Time} - {Start Time})*24)*60), 0)) --> will give you # of minutes

=HOUR(TIME(0, ((({End Time} - {Start Time})*24)*60), 0)) --> will give you # of Hours

With this formula, if Start Time = 9:55am and End Time = 8:45pm, then my result is

50 minutes and 10 hours, I think this is what you want.

okay, if you want your exact output, use this (an exact copy from my document:

= CONCATENATE(HOUR(TIME(0, (((C8-C7)*24)*60), 0)), " hours and ", MINUTE(TIME(0, (((C8-C7)*24)*60), 0)), " minutes")

Cell C7 = start time

Cell C8 = end time

you can use any cells you want by making appropriate changes to the formula, but this should get you started.

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.