Help on a formula please

skillet9

New Member
Joined
May 2, 2005
Messages
34
Help on a formula please - how do you calculate the time between 2 fields? Example - Cell1: 11/01/05 1:30 PM - Cell 2: 11/02/05 1:35 PM. How do I do the formula to in Cell3 to show 24:05? Thanks
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Domenic

MrExcel MVP
Joined
Mar 10, 2004
Messages
19,403
Try...

=A2-A1

...and custom format the cell as [h]:mm or [hh]:mm.

Hope this helps!
 

Watch MrExcel Video

Forum statistics

Threads
1,119,002
Messages
5,575,499
Members
412,670
Latest member
Khin Zaw Htwe
Top