Breaking News: Grepper is joining You.com. Read the official announcement!

Time and date maths in Excel

Clear Chinchilla answered on May 1, 2022 Popularity 8/10 Helpfulness 3/10

answer Time and date maths in Excel

related Date and Time maths with Excel

Time and date maths in Excel

Comment

=A2-B2	Calculates the difference between the time values in cells A2 and B2.
=TIMEVALUE("8:30 PM") - TIMEVALUE("6:40 AM")	Calculates the difference between the specified times.
=TIME(HOUR(A2), MINUTE(A2), SECOND(A2)) - TIME(HOUR(B2), MINUTE(B2), SECOND(B2))	Calculates the time difference between values in cells A2 and B2 ignoring the date difference, when the cells contain both the date and time values.

Popularity 8/10 Helpfulness 3/10 Language excel

Source: Grepper

Tags: excel time

Link to this answer
Share Copy Link

Contributed on May 01 2022

Clear Chinchilla

0 Answers Avg Quality 2/10

Closely Related Answers

Date and Time maths with Excel

Comment

=TEXT(B2-A2, "h:mm:ss")

Popularity 8/10 Helpfulness 2/10 Language excel

Source: Grepper

Tags: time date excel e

Link to this answer
Share Copy Link

Contributed on May 01 2022

Clear Chinchilla

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

Time and date maths in Excel

Contents

More Related Answers

Time and date maths in Excel

Closely Related Answers

Date and Time maths with Excel

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.