Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How many hours in the last 7 days did I work?

I need help putting together a formula for these rolling time periods please.
I have hour limits on time worked. I can:
-Work no more than 16 hours straight. And,
-Work no more than 16 in any 24 hours. And
-No more than 28 in any 48 hours. And
-No more than 72 hours in 7 days. And
-At least 8 hours between shifts.
Very limiting but I've been unable to figure a formula/formulas using time
of the day you worked - or scheduled to be worked. Thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,346
Default How many hours in the last 7 days did I work?

Hi,

You're having a hard time because you want a rolling time period and in
effect the spreadsheet formula to do that, if there were one, would exceed
the character limit on a spreadsheet formula. The best way to approach this
is using VBA - try creating a custom function.

What do you do with hour that exceed any of the rules? What about weekends
and holidays? Can work extend across the midnight hour?

Cheers,
Shane Devenshire


"Sewfoolish" wrote:

I need help putting together a formula for these rolling time periods please.
I have hour limits on time worked. I can:
-Work no more than 16 hours straight. And,
-Work no more than 16 in any 24 hours. And
-No more than 28 in any 48 hours. And
-No more than 72 hours in 7 days. And
-At least 8 hours between shifts.
Very limiting but I've been unable to figure a formula/formulas using time
of the day you worked - or scheduled to be worked. Thanks

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How many hours in the last 7 days did I work?

Thanks for the reply... No wonder I couldn't figure it out!

I work at a Nuclear Station and the NRC won't allow you to work excessive
hours (and aren't you glad:) ) Actually, the rules are even more restrictive
on time (time to turnover work to the next shift doesn't count), but this
will get me really close. We have to fill out a request to exceed the limits
by even 5 minutes. It would be great if I had a way to look ahead to see
easily/fast what time I might need to leave if I don't want to fill out a
request and talk to a VP. Or to take a beating (lol) when I do miscalculate
(that pesky lunch time trips me up). With that many criteria, it's easy to
get mixed up.

As for the hours, it runs across weekends, holidays, and midnight.

Thanks for the help.
.........
"Shane Devenshire" wrote:

Hi,

You're having a hard time because you want a rolling time period and in
effect the spreadsheet formula to do that, if there were one, would exceed
the character limit on a spreadsheet formula. The best way to approach this
is using VBA - try creating a custom function.

What do you do with hour that exceed any of the rules? What about weekends
and holidays? Can work extend across the midnight hour?

Cheers,
Shane Devenshire


"Sewfoolish" wrote:

I need help putting together a formula for these rolling time periods please.
I have hour limits on time worked. I can:
-Work no more than 16 hours straight. And,
-Work no more than 16 in any 24 hours. And
-No more than 28 in any 48 hours. And
-No more than 72 hours in 7 days. And
-At least 8 hours between shifts.
Very limiting but I've been unable to figure a formula/formulas using time
of the day you worked - or scheduled to be worked. Thanks

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting total number of hours (24 hours) into days MV Rao Excel Discussion (Misc queries) 1 January 24th 08 01:50 PM
Subtract time between certain days/work hours? lisa b. Excel Worksheet Functions 2 July 17th 06 10:26 PM
Convert days in decimal to days:hours:minutes Todd F. Excel Worksheet Functions 7 March 16th 06 08:17 PM
Convert decimal days to Days,hours, minutes Todd F. Excel Worksheet Functions 3 March 14th 06 04:38 PM
Problem converting Hours to Days, Hours, Minutes Zyzzx Excel Worksheet Functions 4 October 24th 05 05:19 PM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"