Forum Discussion

Anonymous

Apr 17, 2019

Solved

Time in digital (for large numbers)

Hello ... my first post here. :) As a freelancer, I use Excel to track the hours I work on a particular job. I then convert the total time worked (say 2:45 which is formatted as h:mm) into deci...

Formulas and Functions

Twifoo
Apr 17, 2019
Always remember that hours are stored as decimals of 1 day, which is equivalent to 24 hours.

Twifoo

Silver Contributor

Apr 17, 2019

Simply multiply by 24.

Anonymous
Apr 17, 2019
It worked. I cannot believe it was that simple. *slaps head*
- Twifoo
  Silver Contributor
  Apr 17, 2019
  Always remember that hours are stored as decimals of 1 day, which is equivalent to 24 hours.