Forum Discussion

Tiffa1988's avatar
Tiffa1988
Copper Contributor
Oct 14, 2023

How do I add and subtract decimals in separate columns?

I am trying to make comp time balances automatically populate just by putting in how much time someone is earning or how much time someone is using. The time is minutes to decimals. Anyone know how I...
excel
rachel's avatar
rachel
Iron Contributor
Oct 15, 2023

Tiffa1988 

 

I think you can use =TIME() function.

e.g. to calculate time interval between 14:15 to 14:30, you can input 

=TIME(14, 30, 0)-TIME(14, 15, 0)

 

If you want to format the output, you can use =TEXT() function:

=TEXT(TIME(14, 30, 0)-TIME(14, 15, 0),"hh:mm:ss;@")

 

output will be like this:

 

 

 

 

Resources