Excel: How to convert time format into number format that can be added?

[Frances Jones]

Hi
I just joined this wonderful forum. My name is Frances. I am creating a timesheet in which total hours are both expressed in number format and time format. My problem is that I am trying to add both formats figures to arrive at total hours worked and I can figure out how to either convert the number format or the time format so I get a grant total from both in number format. I appreciate any help on this since I am totally baffled by the problem.
Many thanks, Frances.

[tigeravatar]

Frances,

Welcome to the forum!
Excel handles dates/times as datecodes. Each whole number is 1 whole day, and then a fraction is used to determine the time. So if you're just working with times and not dates, Excel uses 0.25 as the datecode for 6:00 AM because 6:00 AM is one fourth of the way through a whole day. Using this, you can convert a time value to the number of hours with *24 (0.25 * 24 = 6) because there are 24 hours in a day.
Or you can convert a time value to the number of minutes with *24*60 (0.25*24*60 = 360) because there are 60 minutes in an hour.

Without seeing some sample data and expected results however, its difficult to give you any information more specific to your requirements.