ExcelBanter - time formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - time formula (https://www.excelbanter.com/excel-discussion-misc-queries/109718-time-formula.html)

flvo

time formula

how to calculate a cell time format with cell currency format.
for example, I want that 00:01:00 = $1.00

Allllen

time formula

Cell A1 is 00:01:00
Cell A2 is =A1*24*60, and format it as currency $
--
Allllen

"flvo" wrote:

how to calculate a cell time format with cell currency format.
for example, I want that 00:01:00 = $1.00

All times are GMT +1. The time now is 09:48 PM.