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

=?Utf-8?B?U3RldmUgTGluZHNheQ==?=
Guest
Posts: n/a

 7th Dec 2004
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?

Frank Kabel
Guest
Posts: n/a

 7th Dec 2004
Hi
as starting point:
http://j-walk.com/ss/excel/files/timesht.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Steve Lindsay" <Steve (E-Mail Removed)> schrieb im
Newsbeitrag news:783C78CD-ED49-4252-9E42-(E-Mail Removed)...
> 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?

Jason Morin
Guest
Posts: n/a

 7th Dec 2004
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?
>.
>

=?Utf-8?B?c2hlZGV2ZWwxNDM=?=
Guest
Posts: n/a

 8th Dec 2004

"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?

=?Utf-8?B?U3RldmUgTGluZHNheQ==?=
Guest
Posts: n/a

 11th Dec 2004
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 (E-Mail Removed)> schrieb im
> Newsbeitrag news:783C78CD-ED49-4252-9E42-(E-Mail Removed)...
> > 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?

>
>

=?Utf-8?B?U3RldmUgTGluZHNheQ==?=
Guest
Posts: n/a

 11th Dec 2004
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?
> >.
> >

>

=?Utf-8?B?RGF2aWRmcm9zdA==?=
Guest
Posts: n/a

 26th Jan 2005

"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?

=?Utf-8?B?VG9ueQ==?=
Guest
Posts: n/a

 3rd Jun 2005
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 (E-Mail Removed)> schrieb im
> Newsbeitrag news:783C78CD-ED49-4252-9E42-(E-Mail Removed)...
> > 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?

>
>

George Nicholson
Guest
Posts: n/a

 3rd Jun 2005

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" <(E-Mail Removed)> wrote in message
news:1D617FFB-BEFB-45C4-8425-(E-Mail Removed)...
> 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 (E-Mail Removed)> schrieb im
>> Newsbeitrag news:783C78CD-ED49-4252-9E42-(E-Mail Removed)...
>> > 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?

>>
>>

=?Utf-8?B?VG9ueQ==?=
Guest
Posts: n/a

 7th Jun 2005
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" <(E-Mail Removed)> wrote in message
> news:1D617FFB-BEFB-45C4-8425-(E-Mail Removed)...
> > 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 (E-Mail Removed)> schrieb im
> >> Newsbeitrag news:783C78CD-ED49-4252-9E42-(E-Mail Removed)...
> >> > 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 Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post =?Utf-8?B?dHJ5aW5ndG9sZWFybg==?= Microsoft Excel Misc 1 19th Nov 2006 11:24 PM StargateFan Microsoft Excel Misc 8 7th Jan 2006 08:35 PM bigjess007 Microsoft Excel Worksheet Functions 2 20th Jul 2004 08:28 AM Darren Elsom Microsoft Excel Programming 3 21st Mar 2004 10:41 PM Darren Elsom Microsoft Excel Worksheet Functions 2 20th Mar 2004 07:08 PM

Features