EXCEL formula for Time

By rlimosnerojr •

Need your help guys who knows more about Excel.

I have this file that I want to solve.

I have to solve the time difference that automatically computes the Hours and Minutes in the process.

Scenario.

If B3 IS < or = to A3, result must be On Time else Late.

But I want to solved this scenario below

Standard Time of arrival defaults: 01:40 today

Data Time received: 23:30 yesterday

Result should read show as: On Time.

Please do help me to create a formula in excel.

Thank you so much

Roger

Share : Share

2 comments Sort by rating

By rlimosnerojr• 11 Jul 2015 12:20

Thank you so much but can below scenario is I want to solve

But I want to solved this scenario below

Standard Time of arrival defaults: 01:40 today

Data Time received: 23:30 yesterday

Result should read show as: On Time.

Please do help me to create a formula in excel.

Thank you so much

By sur_b4u• 11 Jul 2015 12:17

Rating: 5/5

=IF(A3>=B3,"On Time","Late")

More from Qatar Living

Qatar’s top beaches for water sports thrills

Let's dive into the best beaches in Qatar, where you can have a blast with water activities, sports and all around fun times.

Most Useful Apps In Qatar - Part Two

This guide brings you the top apps that will simplify the use of government services in Qatar.

Most Useful Apps In Qatar - Part One

this guide presents the top must-have Qatar-based apps to help you navigate, dine, explore, access government services, and more in the country.

Winter is coming – Qatar’s seasonal adventures await!

Qatar's winter months are brimming with unmissable experiences, from the AFC Asian Cup 2023 to the World Aquatics Championships Doha 2024 and a variety of outdoor adventures and cultural delights.

7 Days of Fun: One-Week Activity Plan for Kids

Stuck with a week-long holiday and bored kids? We've got a one week activity plan for fun, learning, and lasting memories.

Wallet-friendly Mango Sticky Rice restaurants that are delightful on a budget

Fasten your seatbelts and get ready for a sweet escape into the world of budget-friendly Mango Sticky Rice that's sure to satisfy both your cravings and your budget!

Places to enjoy Mango Sticky Rice in high-end elegance

Delve into a world of culinary luxury as we explore the upmarket hotels and fine dining restaurants serving exquisite Mango Sticky Rice.

Where to celebrate World Vegan Day in Qatar

Celebrate World Vegan Day with our list of vegan food outlets offering an array of delectable options, spanning from colorful salads to savory shawarma and indulgent desserts.

My account

My saved ads

My saved searches

Logout

EXCEL formula for Time

More from Qatar Living