I'm adding enroute times together using your basic XX:XX which is separated
by the colen. The total time will come to, say, 1:35 total time (one hour and
35 minutes). I want the cell to display, however, 95 minutes. Can this be
done?
Pete
I'm adding enroute times together using your basic XX:XX which is separated
by the colen. The total time will come to, say, 1:35 total time (one hour and
35 minutes). I want the cell to display, however, 95 minutes. Can this be
done?
Pete
=A1*24*60
format as general, or if you don't neet integer minutes but just want to
display minutes use
a custom format like [mm]
--
Regards,
Peo Sjoblom
"petek" <[email protected]> wrote in message
news:[email protected]...
> I'm adding enroute times together using your basic XX:XX which is
separated
> by the colen. The total time will come to, say, 1:35 total time (one hour
and
> 35 minutes). I want the cell to display, however, 95 minutes. Can this be
> done?
>
> Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks