My problem is related to the above function.
I have 2 sets of times... on start and one end.... basically in columns A6 and B6 respectively. in C6 I have to calculate the difference in times... which is usually under 5 hours. And that works fine... but this is done on a a daily basis, at the end of the week i have to calculate all the differences in time.
My problem arrises when TIMEVALUE() requires a text datafield, and the answer of the difference is a custom. Therefore I cannot calculate the weekly total because it is in custom and not text.
Kinda new to excel so if u please bear with me.
Thank you.
I have 2 sets of times... on start and one end.... basically in columns A6 and B6 respectively. in C6 I have to calculate the difference in times... which is usually under 5 hours. And that works fine... but this is done on a a daily basis, at the end of the week i have to calculate all the differences in time.
My problem arrises when TIMEVALUE() requires a text datafield, and the answer of the difference is a custom. Therefore I cannot calculate the weekly total because it is in custom and not text.
Kinda new to excel so if u please bear with me.
Thank you.