If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 calculating timesheet, time-in/time-out = total hours & minutes, .
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## calculating timesheet, time-in/time-out = total hours & minutes, .

#1
December 7th 04, 10:45 PM
 Steve Lindsay external usenet poster Posts: n/a
calculating timesheet, time-in/time-out = total hours & minutes, .

Need to create an Excel Timesheet that calculates the hours and minutes
worked daily, based on the time-in/time-out. Then allow the calculated daily
time to total for the week. Am having to make Excel jump through hoops so
far. Any ideas/suggestions?
#3
December 7th 04, 10:55 PM
 Jason Morin external usenet poster Posts: n/a

See Chip Pearson's site for an example timesheet:

http://www.cpearson.com/excel/overtime.htm

HTH
Jason
Atlanta, GA

>-----Original Message-----
>Need to create an Excel Timesheet that calculates the

hours and minutes
>worked daily, based on the time-in/time-out. Then allow

the calculated daily
>time to total for the week. Am having to make Excel jump

through hoops so
>far. Any ideas/suggestions?
>.
>

#4
December 8th 04, 10:05 AM
 shedevel143 external usenet poster Posts: n/a

"Steve Lindsay" wrote:

> Need to create an Excel Timesheet that calculates the hours and minutes
> worked daily, based on the time-in/time-out. Then allow the calculated daily
> time to total for the week. Am having to make Excel jump through hoops so
> far. Any ideas/suggestions?

#5
December 10th 04, 11:59 PM
 Steve Lindsay external usenet poster Posts: n/a

Frank,
Thank you that was exactly what I need. Thank you again.

"Frank Kabel" wrote:

> Hi
> as starting point:
> http://j-walk.com/ss/excel/files/timesht.htm
>
> --
> Regards
> Frank Kabel
> Frankfurt, Germany
>
> "Steve Lindsay" <Steve > schrieb im
> Newsbeitrag ...
> > Need to create an Excel Timesheet that calculates the hours and

> minutes
> > worked daily, based on the time-in/time-out. Then allow the

> calculated daily
> > time to total for the week. Am having to make Excel jump through

> hoops so
> > far. Any ideas/suggestions?

>
>

#6
December 10th 04, 11:59 PM
 Steve Lindsay external usenet poster Posts: n/a

Jason,
Great info. Thank you!

"Jason Morin" wrote:

> See Chip Pearson's site for an example timesheet:
>
> http://www.cpearson.com/excel/overtime.htm
>
> HTH
> Jason
> Atlanta, GA
>
> >-----Original Message-----
> >Need to create an Excel Timesheet that calculates the

> hours and minutes
> >worked daily, based on the time-in/time-out. Then allow

> the calculated daily
> >time to total for the week. Am having to make Excel jump

> through hoops so
> >far. Any ideas/suggestions?
> >.
> >

>

#7
January 26th 05, 01:37 PM
 Davidfrost external usenet poster Posts: n/a

"Steve Lindsay" wrote:

> Need to create an Excel Timesheet that calculates the hours and minutes
> worked daily, based on the time-in/time-out. Then allow the calculated daily
> time to total for the week. Am having to make Excel jump through hoops so
> far. Any ideas/suggestions?

#8
June 3rd 05, 06:02 PM
 Tony external usenet poster Posts: n/a

Hi Frank,

what have I to do, if I want to display in the summary of total hours more
than 24 hours? I have created my own timesheet and if I have in the summary
of total hours more than 24, it doesn't work correctly.

Thanks.

Tony

Frank Kabel pÃ*Å¡e:

> Hi
> as starting point:
> http://j-walk.com/ss/excel/files/timesht.htm
>
> --
> Regards
> Frank Kabel
> Frankfurt, Germany
>
> "Steve Lindsay" <Steve > schrieb im
> Newsbeitrag ...
> > Need to create an Excel Timesheet that calculates the hours and

> minutes
> > worked daily, based on the time-in/time-out. Then allow the

> calculated daily
> > time to total for the week. Am having to make Excel jump through

> hoops so
> > far. Any ideas/suggestions?

>
>

#9
June 3rd 05, 11:15 PM
 George Nicholson external usenet poster Posts: n/a

Under FormatCells>Number>Time: "37:30:55" would display 120:30:00 for 5
days, 30 minutes.
This is the same as FormatCells>Number>Custom: [h]:mm:ss

Alternatively, the John Walkenbach sheet that Frank directed you to uses a
Custom format [h]:mm. This would display as 120:30

HTH,
--
George Nicholson

"Tony" > wrote in message
...
> Hi Frank,
>
> what have I to do, if I want to display in the summary of total hours more
> than 24 hours? I have created my own timesheet and if I have in the
> summary
> of total hours more than 24, it doesn't work correctly.
>
> Thanks.
>
> Tony
>
> Frank Kabel píse:
>
>> Hi
>> as starting point:
>> http://j-walk.com/ss/excel/files/timesht.htm
>>
>> --
>> Regards
>> Frank Kabel
>> Frankfurt, Germany
>>
>> "Steve Lindsay" <Steve > schrieb im
>> Newsbeitrag ...
>> > Need to create an Excel Timesheet that calculates the hours and

>> minutes
>> > worked daily, based on the time-in/time-out. Then allow the

>> calculated daily
>> > time to total for the week. Am having to make Excel jump through

>> hoops so
>> > far. Any ideas/suggestions?

>>
>>

#10
June 7th 05, 03:51 PM
 Tony external usenet poster Posts: n/a

Thank you George for your support. Now it works properly.

Best regards

Tony

George Nicholson pÃ*Å¡e:

> How are your cells formatted?
>
> Under FormatCells>Number>Time: "37:30:55" would display 120:30:00 for 5
> days, 30 minutes.
> This is the same as FormatCells>Number>Custom: [h]:mm:ss
>
> Alternatively, the John Walkenbach sheet that Frank directed you to uses a
> Custom format [h]:mm. This would display as 120:30
>
> HTH,
> --
> George Nicholson
>
> Remove 'Junk' from return address.
>
>
> "Tony" > wrote in message
> ...
> > Hi Frank,
> >
> > what have I to do, if I want to display in the summary of total hours more
> > than 24 hours? I have created my own timesheet and if I have in the
> > summary
> > of total hours more than 24, it doesn't work correctly.
> >
> > Thanks.
> >
> > Tony
> >
> > Frank Kabel pÃ*se:
> >
> >> Hi
> >> as starting point:
> >> http://j-walk.com/ss/excel/files/timesht.htm
> >>
> >> --
> >> Regards
> >> Frank Kabel
> >> Frankfurt, Germany
> >>
> >> "Steve Lindsay" <Steve > schrieb im
> >> Newsbeitrag ...
> >> > Need to create an Excel Timesheet that calculates the hours and
> >> minutes
> >> > worked daily, based on the time-in/time-out. Then allow the
> >> calculated daily
> >> > time to total for the week. Am having to make Excel jump through
> >> hoops so
> >> > far. Any ideas/suggestions?
> >>
> >>

>
>
>

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 Similar Threads Thread Thread Starter Forum Replies Last Post Problems calculating total hours LolaK Excel Discussion (Misc queries) 1 December 14th 04 04:23 PM Timesheet hours will not total. Help. Kelly Excel Discussion (Misc queries) 1 December 6th 04 04:24 PM Subtracting paid hours from unpaid hours ejerry7 Excel Worksheet Functions 5 November 29th 04 04:16 AM Calculating effective time from start/end date+time Stefan Stridh Excel Worksheet Functions 8 November 27th 04 03:50 PM Help! I am stuck calculating Days, Hours, Mins please help OB1 Excel Worksheet Functions 3 November 15th 04 05:17 PM

All times are GMT +1. The time now is 01:59 AM.