Time format/duration help!!

JuleeM13 · Mar 14th, 2002, 12:04 PM

I'm driving myself crazy trying to figure this out. I have two sets of data that are pulled from databases, both representing the amount of time someone worked. One shows the time as a decimal in minues, for example 91.23 (91 minutes), and the other is shown in time format, example 1:31. My boss wants a total time worked but in order to add the data I need to have it in the same format. Just changing the cell format doesn't work. Also changing the format in the databases is out of the question. Does anyone know of a way to do this. I'm at a loss and ready to start pulling my hair out. Thanks!
~julee~

Al Chara · Mar 14th, 2002, 12:12 PM

Try multiplying your time by 1440. Take the column that has 1:31; multiply it by 1440; and format the column to display a number to give 91 minutes.

I hope this helps.
Kind regards, Al.

[ This Message was edited by: Al Chara on 2002-03-14 11:13 ]

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

Mar 14th, 2002, 12:04 PM	#1
JuleeM13 New Member Join Date: Mar 2002 Posts: 8	I'm driving myself crazy trying to figure this out. I have two sets of data that are pulled from databases, both representing the amount of time someone worked. One shows the time as a decimal in minues, for example 91.23 (91 minutes), and the other is shown in time format, example 1:31. My boss wants a total time worked but in order to add the data I need to have it in the same format. Just changing the cell format doesn't work. Also changing the format in the databases is out of the question. Does anyone know of a way to do this. I'm at a loss and ready to start pulling my hair out. Thanks! ~julee~

Mar 14th, 2002, 12:12 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Try multiplying your time by 1440. Take the column that has 1:31; multiply it by 1440; and format the column to display a number to give 91 minutes. I hope this helps. Kind regards, Al. [ This Message was edited by: Al Chara on 2002-03-14 11:13 ]