Remember Me?

#1
December 7th 04, 11:45 PM
 Steve Lindsay 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?

#2
December 7th 04, 11:53 PM
 Frank Kabel Posts: n/a

#3
December 7th 04, 11:55 PM
 Jason Morin 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, 11:05 AM
 shedevel143 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 11th 04, 12:59 AM
 Steve Lindsay 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 11th 04, 12:59 AM
 Steve Lindsay 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, 02:37 PM
 Davidfrost 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 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 Posts: n/a

Under FormatCellsNumberTime: "37:30:55" would display 120:30:00 for 5
days, 30 minutes.
This is the same as FormatCellsNumberCustom: [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 Posts: n/a

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

Best regards

Tony

George Nicholson pÃ*Å¡e:

Under FormatCellsNumberTime: "37:30:55" would display 120:30:00 for 5
days, 30 minutes.
This is the same as FormatCellsNumberCustom: [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?

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post LolaK Excel Discussion (Misc queries) 1 December 14th 04 05:23 PM Kelly Excel Discussion (Misc queries) 1 December 6th 04 05:24 PM ejerry7 Excel Worksheet Functions 5 November 29th 04 05:16 AM Stefan Stridh Excel Worksheet Functions 8 November 27th 04 04:50 PM OB1 Excel Worksheet Functions 3 November 15th 04 06:17 PM

All times are GMT +1. The time now is 06:41 AM.