Solved

Another Time Question in excel...going past midnight

Posted on 2011-02-22
2
267 Views
Last Modified: 2012-06-27
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
Comment
Question by:bvanscoy678
2 Comments
 
LVL 50

Accepted Solution

by:
barry houdini earned 500 total points
ID: 34956233
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
 

Author Closing Comment

by:bvanscoy678
ID: 34956433
Thanks, worked perfect. I appreciate it.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question