| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
|
#4
|
|||
|
|||
|
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? |
|
#5
|
|||
|
|||
|
How are your cells formatted?
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 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? |
|
#6
|
|||
|
|||
|
Thank you George for your support. Now it works properly.
Best regards Tony George Nicholson pÃ*Å¡e: How are your cells formatted? 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 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? |
|
#7
|
|||
|
|||
|
calculating timesheet, time-in/time-out = total hours & minute
To cut a long story short, I have used the [h]:mm format to solve the same
problem of calculating time over 24 hours. Just wondered what exactly the [] do?? Regards Simon "George Nicholson" wrote: How are your cells formatted? 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 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? |
|
#8
|
|||
|
|||
|
calculating timesheet, time-in/time-out = total hours & minute
It only displays time values 24, the numbers underneath are all the same
-- Regards, Peo Sjoblom "S Barnes" wrote in message ... To cut a long story short, I have used the [h]:mm format to solve the same problem of calculating time over 24 hours. Just wondered what exactly the [] do?? Regards Simon "George Nicholson" wrote: How are your cells formatted? 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 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? |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculating timesheet, time-in/time-out = total hours & minute
What do you put if you don't have a lunch break?
"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? |
|
#10
|
|||
|
|||
|
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? . |
|
#11
|
|||
|
|||
|
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? . |
|
#12
|
|||
|
|||
|
"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? |
|
#13
|
|||
|
|||
|
"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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problems calculating total hours | Excel Discussion (Misc queries) | |||
| Timesheet hours will not total. Help. | Excel Discussion (Misc queries) | |||
| Subtracting paid hours from unpaid hours | Excel Worksheet Functions | |||
| Calculating effective time from start/end date+time | Excel Worksheet Functions | |||
| Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions | |||
Hybrid Mode
