Convert a time or duration to the total hours

Hello,

I have a column that finds hours difference and I would like to convert it to numbers.

for example:
08:30 → 8.5
When I try different formulas it always round up the number, but I need the exact time.

Would live to get your help.

Thanks in advance,
Adi

@adibar,

MID("14:20",1,LEN("14:20")-3)+right("14:20",2)/60

Replace the "14:20"s with your difference formula or column reference.

1 Like

Thanks a lot!!!
works perfect & save me so much time! :pray: :100::pray:

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.