Hours and minutes difference between two times in Excel

0 votes

I have two columns of data. The first one is sunset on a particular day X and the next column is a time a few hours later but on day X+1 (as at 00:00 day X+1 comes in). How can I calculate the number of hours between sunset on day X and the time in the second column which is just a few hours later but on day X+1?

The data is in hh:mm:ss format as below:

https://i.stack.imgur.com/5EFMI.png

Mar 23 in Database by Edureka
• 9,320 points
21 views

1 answer to this question.

0 votes

Using the TEXT function in Excel is another simple way to calculate the time difference between two dates: Calculate the number of hours between two dates: TEXT = (B2-A2, "h") Return the hours and minutes between the following two times: TEXT = (B2-A2, "h:mm") Between two times, return the hours, minutes, and seconds: TEXT = (B2-A2, "h:mm:ss")

Calculate time in Excel: time difference, add, subtract and sum times -  Ablebits.com

answered Mar 25 by Edureka
• 8,820 points

Related Questions In Database

0 votes
1 answer

Difference between single and double quotes in SQL

Single quotes are used to indicate the ...READ MORE

answered Sep 11, 2018 in Database by CodingByHeart77
• 3,720 points
13,090 views
0 votes
1 answer

Difference between clustered and non clustered index in SQL

The differences between the clustered and non ...READ MORE

answered Sep 28, 2018 in Database by Sahiti
• 6,360 points
835 views
0 votes
1 answer

Can you please explain the difference between inner join and outer join in database?

Hi Suraj, You have a doubt regarding inner join ...READ MORE

answered May 28, 2019 in Database by sampriti
• 1,120 points
413 views
0 votes
1 answer

Difference between datetime and timestamp in sqlserver?

Timestamp is a synonym for rowversion, according ...READ MORE

answered Feb 16 in Database by Vaani
• 5,040 points
136 views
0 votes
1 answer

Retrieve epay.info Balance with VBA and Excel

This code should log you in, provided ...READ MORE

answered Sep 5, 2018 in Blockchain by digger
• 26,720 points
322 views
0 votes
1 answer

ImportError: openpyxl is required for loading excel format files

Forget the PsychoPy complications for the time ...READ MORE

answered Oct 3, 2018 in Python by Priyaj
• 58,060 points
288 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 58,060 points
3,126 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
2,514 views
0 votes
1 answer

Excel - count days in each month between two dates (both dates available)

Anyway, here's an alternative completeness approach based ...READ MORE

answered Apr 11 in Database by Edureka
• 8,820 points
13 views
0 votes
1 answer

Merging Two excel files as two sheets in one workbook in java

Basically for this, you need to create ...READ MORE

answered Feb 21 in Database by Edureka
• 8,820 points
21 views
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP