Hi all, I have table one column contains data like 8, 8.5 etc and second column contains 09:45, 8:35 etc. How to subtract 9:45 and 8 , 8.5 ad 8:35. Can anyone solution. Thank you.

Hi, How about the following? [image] TimeSpan.Parse("8:35")-TimeSpan.FromHours(8.5) Regards,

How to subtract 8.5 and 9:45?

Yoichi (Yoichi) April 3, 2023, 12:11pm 5

Hi,

How about the following?

TimeSpan.Parse("8:35")-TimeSpan.FromHours(8.5)

Regards,

2 Likes

Forum Engagement Daily Reports

Topic		Replies	Views
Subtract one time period with the other obtained from Excel Studio excel , activities , question , data_manipulation	23	2108	March 6, 2020
Convert double to date/time Help	5	1792	May 14, 2020
Assign difference in a row's datetime to column Help datatable , excel , activities , string , question	6	1486	December 13, 2019
How to Subtract hh:mm:ss:ff with hh:mm:ss:ff Studio studio , question	9	1390	August 1, 2021
Subtract the Time from current date time Help	10	8073	December 22, 2019