View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff Biff is offline
external usenet poster
 
Posts: 1,688
Default Time without date

Try this:

=MOD(L1,1)

Format as h:mm

Biff

"Steve" wrote in message
...
The below is in a pre-dowloaded column, column L
11/14/06 4:19
It has custom formatting as m"/"d"/"yy" "h":"mm

What formula do I need to enter in the M column to just show the 4:19,
keeping the h:mm formatting, because I still need to subtract a time in
one
column from a time in another column.

Thanks,

Steve