In Excel, how can I find the duration of an event when the start (date and) time and the end (date and) time are known?

Excel uses a simple real number (floating point) to track dates internally. The units are days, so if you take a date in excel and display it as a number, you'll see values like 32756.4245. That means 32756 days since 1/1/1900, and the ".4245" is the fraction of a day.

0.5 days is 12 hours, 0.25 days is 6 hours, and so forth.

This makes it easy to do math with dates -- just subtract the date values as numbers and tell Excel to represent the result cells as date/time.

More Questions. Additional questions in this category.

ANSWERBAG BUZZ

Excel duration

Duration in excel

Excel date duration

Duration excel

Time duration in excel

Question

In Excel, how can I find the duration of an event when the start (date and) time and the end (date and) time are known?

Answers. 2 helpful answers below.

Comments

Comments

Did this answer your question? If not, then ask a new question or create a poll.

More Questions. Additional questions in this category.

Follow us on Facebook!

Related Ads

Related Questions

In Excel, I have a column with a start date, and a column with an end date for 20 students that I see once a week. I want to have a function whereby I can put any start date in and any end date and have excel look at all 20 students and ca

I am building a time sheet for employees. Is there a way to take the start time in one cell, the end time in another cell and a date entered in a 3rd cell and total the amount of hours worked?

I have two dates, one starting date and one ending date, there is a time line between the dates, if I go beyond the end date I would like the cell to turn Red, to indicate that I have gone beyond the ending date, what formula do I use to achieve this.

Hello I'm working with older date in windows. When I change date/time my computer automaticly restart. Then I go in BIOS and set the date 2-3 year early save it, and my coputer work properly. How can work with corect date/time (problems with genuine windo

I need to calculate overtime using excel. I have a formula I use now that calculates hours worked i.e: b1:start time, c1: end time

Professionally Researched

What is the access SQL command for time duration?

How do I export the date from a program into Excel?

When was the date in which the spreadsheet application for Excel was released?

How do I add a calendar date picker to an Excel spreadsheet?

How do I calculate a date in Excel?

ANSWERBAG BUZZ

Answerbag.com
Your favorite Q&A site is on Facebook! Become a fan to connect with the ever-growing community of Answerbaggers, share your thoughts and find out what Answerbag's up to next!

Question

In Excel, how can I find the duration of an event when the start (date and) time and the end (date and) time are known?

Answers. 2 helpful answers below.

Comments

Comments

Did this answer your question? If not, then ask a new question or create a poll.

More Questions. Additional questions in this category.

Follow us on Facebook!

Related Ads

Related Questions

Professionally Researched

ANSWERBAG BUZZ

Answerbag.com Your favorite Q&A site is on Facebook! Become a fan to connect with the ever-growing community of Answerbaggers, share your thoughts and find out what Answerbag's up to next!

Answerbag.com
Your favorite Q&A site is on Facebook! Become a fan to connect with the ever-growing community of Answerbaggers, share your thoughts and find out what Answerbag's up to next!