Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
=A1*24*60 and format as general or number.
-- David Biddulph "Richard" wrote in message ... Is there a way to convert time into a whole number? I have a data set of minutes that I would like to convert. For example, instead of the cell reading :15 I would like for it to read 15. Since Excel does not work with negative time I was hoping this might be a good work around for getting the info I need. Thanks Rich |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Time conversion | Excel Worksheet Functions | |||
time conversion | Excel Discussion (Misc queries) | |||
Time conversion | Excel Worksheet Functions | |||
Time conversion | Excel Worksheet Functions | |||
Time conversion | Excel Discussion (Misc queries) |