One way:

A1: 12/17/2008 13:23
B1: 12/19/2008 15:35

then

C1: B1-A1

Format C1 as '[hh]:mm' to display '50:12'

Or if you want integral hours (since XL stores times as fractional
days):

C1: =ROUND((B1-A1)*24,0)

to display '50'

In article
,
wrote:

How do you put the Num-Days and Hours into total hours

on Excel, I have 2 fields.
one (number format cell) has the number of days.
another (time format cell) has hh:mm is there a way to make another
cell to have days/hours?

OR, if you would rather.

12/17/2008 13:23
12/19/2008 15:35
given these "date and time" fields, is there a way to derive the total
number of hours between the two?

Thanks,
Crzzy1