Hours and minutes - ExcelBanter

Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 30

Hours and minutes

If I want to record time spent is there a function I can use to add time,
that is for example:

15mins + 30mins + 90mins = 2hrs 15mins or 135mins.

Please and thank you

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded 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
Converting total minutes into hours and minutes in Excel	colette	Excel Worksheet Functions	11	December 26th 07 07:24 PM
converting Days Hours & minutes into just minutes in excel	Six Sigma Blackbelt	Excel Discussion (Misc queries)	5	April 28th 06 09:45 PM
how to change a decimal number (minutes) into hours and minutes?	Erwin	Excel Discussion (Misc queries)	2	November 5th 05 04:22 PM
add hours & minutes to other hours & minutes to receive total hou.	Wes	Excel Worksheet Functions	2	March 1st 05 11:33 PM
add column of minutes, show total in hours & minutes	glider pilot	Excel Worksheet Functions	1	December 30th 04 10:27 PM

All times are GMT +1. The time now is 12:16 AM.

Menu

About Us