エクセルメモ

Excel

Last updated at 2024-05-17Posted at 2024-05-17

=IF((E6 - D6) >= TIME(6, 0, 0),
    IF((E6 - D6 - TIME(0, 45, 0)) >= TIME(8, 0, 0),
        IF((E6 - D6 - TIME(0, 45, 0) - TIME(0, 15, 0)) >= TIME(8, 0, 0),
            E6 - D6 - TIME(0, 45, 0) - TIME(0, 15, 0),
            TIME(8, 0, 0)),
        E6 - D6 - TIME(0, 45, 0)),
    E6 - D6)

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up