Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Programming > Manipulating Time
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 84
Default Manipulating Time
I need convert time 10:20:24 into minutes so that I can divided a number to
determine how many units are being done a minute.

I don't know how to do this.

Please help

Thanks
Reply With QuoteReply With Quote
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
  
Posts: 11,058
Default Manipulating Time
=A1*1440
and format as General
--
Gary''s Student - gsnu200773
Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Manipulating Arrays Alan Beban[_2_] Excel Programming 5 December 5th 07 05:53 PM
Manipulating Formula jk Excel Programming 3 August 18th 06 02:22 PM
Manipulating shapes thePriest Excel Discussion (Misc queries) 0 April 20th 05 06:41 PM
Manipulating Data in a row Gsurfdude Excel Programming 3 March 23rd 05 07:35 PM
Manipulating DOS from VBA Dave Peterson[_3_] Excel Programming 0 October 17th 03 01:46 AM


All times are GMT +1. The time now is 03:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement