Snasui Excel Forum

Hi dear,
I need your input how to calculate time difference between two time in a cell without use left and right function.

I also attached a template


Thanks

sna wrote: Wed Oct 13, 2021 7:14 pm without use left and right function

What the problem of these functions?

These functions working but my boss didn't need it

I want your boss ask me by himself.

...

Hi Guy,

What's the reason that your boss doesn't need to use left and right functions?

Looks like it could have several functions/formulas to solve the problem like that.

Honestly, in that case, the functions still work then please let your boss uses simple functions such as left and right properly instead of finding out the difficult methods.

Norkaz

thank you I try to explain him because I don't pretty much like complex formula

...

Another way, try this.

B2

=MID(A2,SEARCH("-",A2)+1,99)-MID(A2,1,SEARCH("-",A2)-1)

Norkaz