Hour difference calculation in Power Query

[sanket_sk]

Hi There,

Merry Christmas !!!

Friends I am looking for function / formula to calculate hourly difference in two dates using Power Query.
I tried using hours / total hours and also by combining Hours and minutes but end result was always different than excel calculation ( Competed - Start)
Please help

Closed Calls 19-12.xlsx
	A	B	C
1	WOCOMPLETEDDATE	WOSTARTDATE	Hour Diference
2	16-12-20 11:01	14-12-20 11:00	48:01
3	16-12-20 11:05	14-12-20 10:44	48:21
4	16-12-20 13:18	15-12-20 11:45	25:33
5	16-12-20 13:23	14-12-20 9:26	51:56
6	16-12-20 10:35	15-12-20 8:47	25:48
7	17-12-20 10:49	15-12-20 9:52	48:56
8	17-12-20 10:42	15-12-20 11:19	47:22
9	17-12-20 12:04	16-12-20 8:27	27:37
10	18-12-20 11:29	16-12-20 9:31	49:57
Sheet1

Cell Formulas
Range	Formula
C2:C10	C2	=A2-B2

 

[sandy666]

you forgot to mention the special time format [h]: mm that you used in column C

WOCOMPLETEDDATE	WOSTARTDATE	Subtraction
16/12/2020 11:01	14/12/2020 11:00	2.00:01:00
16/12/2020 11:05	14/12/2020 10:44	2.00:21:07
16/12/2020 13:18	15/12/2020 11:45	1.01:33:41
16/12/2020 13:23	14/12/2020 09:26	2.03:56:24
16/12/2020 10:35	15/12/2020 08:47	1.01:48:19
17/12/2020 10:49	15/12/2020 09:52	2.00:56:40
17/12/2020 10:42	15/12/2020 11:19	1.23:22:31
17/12/2020 12:04	16/12/2020 08:27	1.03:37:08
18/12/2020 11:29	16/12/2020 09:31	2.01:57:32

here the last column format is d.hh:mm:ss where d means days

 

[ThxAlot]

Hi There,

Merry Christmas !!!

Friends I am looking for function / formula to calculate hourly difference in two dates using Power Query.
I tried using hours / total hours and also by combining Hours and minutes but end result was always different than excel calculation ( Competed - Start)
Please help

Closed Calls 19-12.xlsx
	A	B	C
1	WOCOMPLETEDDATE	WOSTARTDATE	Hour Diference
2	16-12-20 11:01	14-12-20 11:00	48:01
3	16-12-20 11:05	14-12-20 10:44	48:21
4	16-12-20 13:18	15-12-20 11:45	25:33
5	16-12-20 13:23	14-12-20 9:26	51:56
6	16-12-20 10:35	15-12-20 8:47	25:48
7	17-12-20 10:49	15-12-20 9:52	48:56
8	17-12-20 10:42	15-12-20 11:19	47:22
9	17-12-20 12:04	16-12-20 8:27	27:37
10	18-12-20 11:29	16-12-20 9:31	49:57
Sheet1

Cell Formulas
Range	Formula
C2:C10	C2	=A2-B2

Hi, there! When you apply subtraction between 2 Datetime data in Power Query, the result is of type Duration; Power Query applies a standard "d.hh:mm:ss" format to the result.