Share via

MOD FUNCTION HELP USING 24 HOUR TIME

Anonymous
2019-08-12T02:38:36+00:00

Hi,

I am creating a productivity worksheet. I want to use the MOD function. I am working with 24 hour time sheets. I have a start time minus a stop time and I want to subtract out different break times. The formula I am using is =MOD(E3-F3,1)*24-G3.  E3 IS 10:15PM F3 IS 4:20AM  the break here is 1.25 but I want to be able to change the break value. Any help would be greatly appreciated.

Thank you,

Robin

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Vijay A. Verma 104.9K Reputation points Volunteer Moderator
2019-08-12T03:28:30+00:00

Hi RobinH2

Greetings! I am Vijay, an Independent Advisor. Your formula looks allright to me.

I am assuming G3 contains the break value of 1.25.

What is the exact issue here? Do you want multiple break times to be incorporated?

Was this answer helpful?

1 person found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-08-12T03:54:16+00:00

    Thanks for the help. I had forgotten to put a space between the time and pm or am

    Was this answer helpful?

    0 comments