Time to digital minutes

		Microsoft Office Forums > Microsoft Excel > Excel
Time to digital minutes

11-23-2016, 07:58 PM

macropod

Windows 7 64bit Time to digital minutes

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,514

Assuming the 00:00:46:00 is in C1, you could use a formula like:
=LEFT(C1,8)*1440

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Why only 3 minutes audio recording	rfwltd	OneNote	1	10-29-2016 01:42 PM
Calculate Average Time Elapsed in Days, hours and minutes	Nina46	Excel	9	09-11-2015 02:09 AM
turnaround time minutes divided by volume	tweeter	Excel	9	11-18-2013 02:09 PM
Forward Unread Messages after X Minutes?	BamaBrad	Outlook	2	03-13-2011 07:57 AM
Documents Take 5 Minutes To Open	Farrar	Word	1	07-23-2007 02:54 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:00 AM.