• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 279
  • Last Modified:

Another Time Question in excel...going past midnight

I made a time calculator the other day with the help from EE. Now, I am trying to build on that to make a time card that will track specialty pay.
We work 24 hour shift (0700-0700). My idea is to make a "sheet log" that will track the time. Then I can use a pivot table to group and total.

I tried simply =F6-E6 which is fine until I hit a time frame that goes accross midnight.
Then, I tired the =MOD(F6-E6,1)*24 that I learned from the time card project.

I am not certain if I have this set up correctly to be able to count the time past midnight.

Thanks pivot-time-card.xlsx
0
bvanscoy678
Asked:
bvanscoy678
1 Solution
 
barry houdiniCommented:
The version with MOD, will work in most cases but if you want to get 24 for 07:00 to 07:00 then try this formula in G6 copied down

=(F6-E6+(E6>=F6))*24

and format as number

see attached

regards, barry
26840183.xls
0
 
bvanscoy678Author Commented:
Thanks, worked perfect. I appreciate it.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now