You are here: HomeExcelTutorials

# Convert to Seconds

## Convert to Seconds

Price: FREE

I copied some data from a website and it comes over as minutes:seconds:tenths of seconds. I want to convert the whole thing to total seconds. I know if you have hours:minutes:seconds you can go =(HOUR(cell)*60*60)+(MINUTE(cell)*60)+SECOND(cell). I am trying variations of this with no luck. Thoughts?
As an example, I want A1=36:35:00 to come out as B1=2195.

Visit publisher's web-site: Convert to Seconds

Category and Tags: ExcelTutorials :

## Related Tutorials

### convert seconds to minutes and seconds

Free: Yes
Tags: Excel › VBA

I have a program that produces seconds such as 89 seconds or 193 seconds or 205 seconds. How do I convert these into minutes and seconds such as 125 = 1 minute and 15 seconds.

### Convert time to decimal seconds

Free: Yes
Tags: Excel ›

I am in need of help to convert a database made up of times in minutes and seconds to decimal seconds.
I have used a custom cell format to enter lap times: [m]:ss.00. Unfortunately I have realized that I can't do the analysis that I want to in this format and now need to convert this from minutes and seconds to seconds only.
For example I have a value of 3:50.45 which I need to convert to 230.45 seconds. Any ideas on a formula as doing this manually will take days and days?!

### [solved] Convert seconds to D:H:MM

Free: Yes
Tags: Excel ›

I have a figure that is in seconds and I need to convert it into D:H:MM and I can't see an easy way to do that.
The convert formula does not cater for converting into D:H:MM.
I've formatted a cell to D:H:MM but I need to find a way of converting can you suggest anything please?
for example:
130 seconds would give 0:0:2 I'm not worried about the left over
90060 seconds would give 1:1:1

### Convert Seconds to Minutes

Free: Yes
Tags: Excel › Functions

I have a phone report that is displaying total time is seconds, for example I get 2136 seconds. How do I convert that to minutes and seconds?

### Convert number into minutes.seconds

Free: Yes
Tags: Excel ›

How do change a number into minutes and seconds.
For example, I had this formula:
(1784 seconds * 26 percent)/60= 7.73
I want to convert the 7.73 into minutes and seconds. So 7.73 would become 8.13 minutes.seconds

## Related Applications & Scripts

### Latitude and Longitude Converter

Free: Yes
Tags: PHP › Excel Converters

This PHP script calculates and converts the decimal value of any latitude and longitude coordinates into easy-to-read degrees, minutes, and seconds.

### cfm2asp: Convert ColdFusion to ASP - Software

Free: No

CFM2ASP is a powerful program to help convert from ColdFusion to Microsoft Active Server Pages (ASP) written in VBScript.
The code editor in CFM2ASP is stocked with tons of your favorite features such as line numbers and auto indent.
Those who have tried to convert a web site or even just a few pages from ColdFusion to ASP know how long this can take. Most people would tell you the best method would be to start over with ASP. Now you can convert a page from CFM to ASP in about a minute.

### PeopleAdmin: who's logged on to which computer

Free: No

PeopleAdmin is a powerful tool that helps you find out who's logged on to which computer in seconds!
ADUC PeopleAdmin is a Microsoft Active Directory based tool that helps you find out who's logged on to which computer in seconds. You can also list computers and their users and save the information to excel, txt, bitmap or printer.
Ok, so you know a certain user is logged on to one of the computers in your network. Problem is, to which one? ADUC PeopleAdmin is a Microsoft Active Directory based tool that allows you to scan your entire network in seconds, and find out on which computer a certain user is logged on ... No more placing stickers on computers, or have your end users search for tags on the most impossible places. ADUC PeopleAdmin offers realtime info on who is logged on to which computer!
Features:
- Scan entire network in seconds
- Easily create lists of computers and users
- Find user on any computer within the network in seconds
- No need for ID-tags on computers anymore
- Support the user without having to go to physical location

### Count down then redirect script

Free: Yes
Tags: JavaScript › Excel Redirection

Occasionally, you may wish to have a redirect page that pauses for a few seconds before sending the visitor off to the destination. For example, there may be important text on the redirect page you wish the visitor to get a chance to read, or a banner ad to see.before proceeding. This redirect script understands that, and pauses for any given seconds before navigating to the target page!

### Convert PowerPoint to DPG

Free: No
Tags: Software › Excel File Conversion

Convert PowerPoint presentation to DPG video with Moyea PPT to DPG Converter for viewing PowerPoint on Nintendo DS.
Moyea PPT to DPG Converter stands out of the groups of PowerPoint to video converters for it can not only keep the original background music, voice narration, animations and transitions, etc. intact, but also enables users to convert several PowerPoint files to videos at one time, with no number limit.